Split no Oracle

SELECT SUBSTR(t.column_one, 1, INSTR(t.column_one, ' ')-1) AS col_one,
       SUBSTR(t.column_one, INSTR(t.column_one, ' ')+<<num char do separador>>) AS col_two
  FROM YOUR_TABLE t

Fonte: http://stackoverflow.com/questions/5199849/split-varchar-into-separate-columns-in-oracle