오라클 문장을 공백 구분자로 분리하기

WITH data AS (
SELECT '가나다라 마바사 아자차카 타파하' AS text FROM dual
) 
SELECT lvl
     , regexp_substr(text, '[^ ]{1,}', 1, lvl)
  FROM data
     , ( SELECT LEVEL lvl FROM dual CONNECT BY LEVEL <= 99) t
 WHERE lvl < = length(text) - length(replace(text, ' ', '')) + 1
;


WITH data AS (
SELECT '가나다라 마바사 아자차카 타파하' AS text FROM dual
) 
SELECT lvl
     , regexp_substr(text, '[^ ]+', 1, lvl)
  FROM data
     , ( SELECT LEVEL lvl FROM dual CONNECT BY LEVEL <= 99) t
 WHERE lvl < = length(text) - length(replace(text, ' ', '')) + 1
;

참고 : http://oracleclub.com/article/57715