[ORACLE]전화번호 자르기! (-) 기준

nvl( Substr( Bbs_Mar_Buy_Tel, 0, Instr(Bbs_Mar_Buy_Tel,'-')-1 ) , ' ')  AS BBS_HP_1,
            nvl( Substr(Substr(Bbs_Mar_Buy_Tel, Instr(Bbs_Mar_Buy_Tel,'-')+1), 0, Instr( Substr(Bbs_Mar_Buy_Tel, Instr(Bbs_Mar_Buy_Tel,'-')+1) , '-')-1) , ' ' ) AS BBS_HP_2,
            nvl( Substr(Substr(Bbs_Mar_Buy_Tel, Instr(Bbs_Mar_Buy_Tel,'-')+1), Instr( Substr(Bbs_Mar_Buy_Tel, Instr(Bbs_Mar_Buy_Tel,'-')+1) , '-')+1) , ' ' )  AS BBS_HP_3,

'000-000-0000';
'000-0001-0000';
'00-001-0000';

전화번호 자르기~!

출처 - http://damipic.tistory.com/entry/Oracle-%EC%A0%84%ED%99%94%EB%B2%88%ED%98%B8-%EC%9E%90%EB%A5%B4%EA%B8%B0-%EA%B8%B0%EC%A4%80