728x90
반응형


SELECT TO_CHAR( TRIM(REGEXP_SUBSTR(ACC_INC_TPDC, '[^,]+', 1, LEVEL)) ) AS ACC_INC_TPCD
, ROWNUM AS RN
FROM
(SELECT TO_CLOB('201,202,111,112,21A,')
|| TO_CLOB('245,246,25C,25B') AS ACC_INC_TPCD
FROM DUAL
)
CONNECT BY INSTR(ACC_INC_TPCD,',',1,LEVEL-1) > 0
;




728x90
반응형

+ Recent posts