oracle 문자열 나누기(핸드폰번호 등)

WITH A AS (SELECT '011-2222-3333' AS P FROM DUAL)
SELECT SUBSTR(P,1,INSTR(P,'-',1,1)-1) AS FIRST
,SUBSTR(P,INSTR(P,'-',1,1)+1,INSTR(P,'-',1,2)-INSTR(P,'-',1,1)-1) AS MIDDLE
,SUBSTR(P,INSTR(P,'-',1,2)+1) AS LAST
FROM A;