오라클 전화번호 쪼개기
2017.07.11 by 동동주1123
SELECT (REGEXP_SUBSTR(전화번호컬럼, '[^-]*') ) AS TEL1, (REGEXP_SUBSTR(SUBSTR(전화번호컬럼, REGEXP_INSTR(전화번호컬럼,'-')+1 , LENGTH(전화번호컬럼)) , '[^-]*') ) AS TEL2, (REGEXP_SUBSTR(전화번호컬럼, '[^-]*$') ) AS TEL3,FROM
개발 2017. 7. 11. 14:08