특정문자열 연결DATA를 Row행단위 결과로 작업

아래 조회값으로 다음의 결과값을 만드시오
------------------------
SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD
FROM DUAL


결과
------------------------
COD
일일일
이이이
삼삼삼
사사사
오오오

--111111
 WITH SAMPLE_TABLE AS(
    SELECT REGEXP_SUBSTR((SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD FROM DUAL), '[^,]+',1,1) AS COL1
         , REGEXP_SUBSTR((SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD FROM DUAL), '[^,]+',1,2) AS COL2
         , REGEXP_SUBSTR((SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD FROM DUAL), '[^,]+',1,3) AS COL3
         , REGEXP_SUBSTR((SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD FROM DUAL), '[^,]+',1,4) AS COL4
         , REGEXP_SUBSTR((SELECT '일일일,이이이,삼삼삼,사사사,오오오' AS COD FROM DUAL), '[^,]+',1,5) AS COL5
      FROM DUAL
 )
 SELECT COD
   FROM SAMPLE_TABLE
UNPIVOT (COD FOR COL IN (COL1,COL2,COL3,COL4,COL5))