[Oracle] Pivot, 가로구문자 문자열을 한컬럼 세로값으로 ( Like Split )

[Oracle] Pivot, 가로구문자 문자열을 한컬럼 세로값으로 ( Like Split )

WITH Tmp AS ( SELECT '1,2,3,4,5,6,7,8,9,10' AS str FROM DUAL ) SELECT REGEXP_SUBSTR (Tmp.str, '[^,]+', 1, LEVEL) pivot_str FROM DUAL, Tmp CONNECT BY REGEXP_SUBSTR (Tmp.str,'[^,]+', 1, LEVEL) IS NOT NULL;