Hi,

You can post the SQL or Oracle related questions in Oracle forum.

The below query should help you.

SELECT trim(DECODE(ROWNUM,1,SUBSTR(STR,1,INSTR(STR,' ',1)),
                                    LENGTH(STR)-LENGTH(REPLACE(STR,' '))+1,SUBSTR(STR,INSTR(STR,' ',-1,1)),
                                     SUBSTR(STR,INSTR(STR,' ',1,ROWNUM-1), INSTR(STR,' ',1,ROWNUM)-INSTR(STR,' ',1,ROWNUM-1))
                               ))  STR1
                 FROM (SELECT 'Jody E Mcquire' STR FROM DUAL),ALL_TABLES
                 WHERE ROWNUM <= LENGTH(STR)-LENGTH(REPLACE(STR,' '))+1
                  ORDER BY ROWNUM