WITH t AS
(
SELECT '000' AS PAR, '11P' AS CHI FROM DUAL UNION ALL
SELECT '11P' AS PAR, '1EX' AS CHI FROM DUAL UNION ALL
SELECT '1EX' AS PAR, '1EA' AS CHI FROM DUAL UNION ALL
SELECT '1EA' AS PAR, '1EK' AS CHI FROM DUAL UNION ALL
SELECT '1EK' AS PAR, '1E1' AS CHI FROM DUAL UNION ALL
SELECT '000' AS PAR, '11S' AS CHI FROM DUAL UNION ALL
SELECT '11S' AS PAR, '1RY' AS CHI FROM DUAL UNION ALL
SELECT '1RY' AS PAR, '1RM' AS CHI FROM DUAL UNION ALL
SELECT '1RM' AS PAR, '1R3' AS CHI FROM DUAL UNION ALL
--SELECT '000' AS PAR, '11S' AS CHI FROM DUAL UNION ALL -- 중복
--SELECT '11S' AS PAR, '1RY' AS CHI FROM DUAL UNION ALL -- 중복
SELECT '1RY' AS PAR, '1RN' AS CHI FROM DUAL UNION ALL
SELECT '1RN' AS PAR, '1R9' AS CHI FROM DUAL UNION ALL
--SELECT '000' AS PAR, '11S' AS CHI FROM DUAL UNION ALL -- 중복
--SELECT '11S' AS PAR, '1RY' AS CHI FROM DUAL UNION ALL -- 중복
SELECT '1RY' AS PAR, '1S3' AS CHI FROM DUAL
)
-- 예시자료에 문제가 있네요???
-- 중복자료는 제거해야 맞겠죠?
SELECT REGEXP_SUBSTR(p, '[^-]+', 1, 2) c1
     , REGEXP_SUBSTR(p, '[^-]+', 1, 3) c2
     , REGEXP_SUBSTR(p, '[^-]+', 1, 4) c3
     , REGEXP_SUBSTR(p, '[^-]+', 1, 5) c4
     , chi                             c5
  FROM (SELECT SYS_CONNECT_BY_PATH(par, '-') p
             , chi
          FROM t
         WHERE CONNECT_BY_ISLEAF = 1
         START WITH par = '000'
         CONNECT BY PRIOR chi = par
        )
;

아..죄송합니다. 제가 중복데이터를 올렸네요..

이렇게 간단하게 되는줄 몰랐네요..

정말 큰 도움 되었습니다.

감사합니다^^