-- 정규식이용
WITH T ( TXT ) AS (
SELECT '11-ABCD-ABCDED-5218101-000000-000000-000000-000000-0000000-000-000-0-0000000' FROM DUAL
)
SELECT REGEXP_SUBSTR( TXT ,'[^-]+', 1 , 4 )
FROM T
by 우리집아찌
[2018.10.08 09:38:17]
-- INSTR 이용
WITH T ( TXT ) AS (
SELECT '11-ABCD-ABCDED-5218101-000000-000000-000000-000000-0000000-000-000-0-0000000' FROM DUAL
)
SELECT SUBSTR(TXT,INSTR( TXT , '-' , 1 ,3 )+1,INSTR( TXT , '-' , 1 ,4 )-INSTR( TXT , '-' , 1 ,3)-1)
FROM T
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.