REGEXP_SUBSTR함수로.SPLIT하기
[Oracle]REGEXP_SUBSTR함수로.SPLIT하기 .. WITH X AS ( SELECT 'NAVER' AS USER_ID ,'NA1,NA2,NA3,NA4,NA5,NA6,' AS RE_CODE FROM DUAL UNION ALL SELECT 'NAVER1' AS USER_ID ,'NA7,NA8,NA9,NA10' AS RE_CODE FROM DUAL ) SELECT REGEXP_SUBSTR(A.RE_CODE, '[^,]+', 1, B.LV) AS RE_CODE FROM X A ,(SELECT LEVEL LV FROM DUAL CONNECT BY LEVEL
더보기