Break one column to multiple columns

[sree_sri]

Hi Jmodic&Stecal,

I modified that code like this and it's working for 3 columns.

SELECT
substr(dname,1,INSTR(dname, ' ', 1, 1))
AS column_1,
substr(dname,INSTR(dname, ' ', 1, 1)+1,decode(instr(dname,' ',instr(dname, ' ',1,1)+1,1),0,50,instr(dname,' ',instr(dname, ' ',1,1)+1,1))-
INSTR(dname, ' ', 1, 1))
AS column_2,

SUBSTR(dname, DECODE(INSTR(dname, ' ', 1, 2),
0, LENGTH(dname)+1,
INSTR(dname, ' ', 1, 2)+1)) AS column_3
from dept
;

Now result looking like this.

< ------------------- ----------------- -----------
harry peter
mag b boston
Keith warn

Thanks Jmodic, Now i am working for 4 columns.

Sree.