Oracle 8.X 에서 지원하는 지는 모르겠는데요...

SELECT  REGEXP_SUBSTR(NM_PATH,'[^>]+')     AS NM1
       ,REGEXP_SUBSTR(NM_PATH,'[^>]+',1,2) AS NM2
       ,REGEXP_SUBSTR(NM_PATH,'[^>]+',1,3) AS NM3
       ,REGEXP_SUBSTR(NM_PATH,'[^>]+',1,4) AS NM4
       ,B.DT
       ,B.QTY
  FROM (
            SELECT  SYS_CONNECT_BY_PATH(A.NM,'>') AS NM_PATH
                   ,A.CHL_ID
              FROM  TR1 A
        START WITH PAR_ID = 0 
        CONNECT BY PRIOR A.CHL_ID = A.PAR_ID
       )    A
        ,TR B
 WHERE  A.CHL_ID = B.CD (+)
 ;

Sys_connect_by_path 는 9i부터 가능
RegExp 는 10g부터 가능
8i 에서 테스트 했습니다. 8.0 이라면 다른 방법으로...


SELECT SUBSTR(nms, INSTR('/'||nms,'/',1,1)
     , INSTR(nms||'/','/',1,1)-INSTR('/'||nms,'/',1,1)) nm1
     , SUBSTR(nms, INSTR('/'||nms,'/',1,2)
     , INSTR(nms||'/','/',1,2)-INSTR('/'||nms,'/',1,2)) nm2
     , SUBSTR(nms, INSTR('/'||nms,'/',1,3)
     , INSTR(nms||'/','/',1,3)-INSTR('/'||nms,'/',1,3)) nm3
     , SUBSTR(nms, INSTR('/'||nms,'/',1,4)
     , INSTR(nms||'/','/',1,4)-INSTR('/'||nms,'/',1,4)) nm4
     , SUBSTR(nms, INSTR('/'||nms,'/',1,5)
     , INSTR(nms||'/','/',1,5)-INSTR('/'||nms,'/',1,5)) nm5
     , SUBSTR(nms, INSTR('/'||nms,'/',1,6)
     , INSTR(nms||'/','/',1,6)-INSTR('/'||nms,'/',1,6)) nm6
     , SUBSTR(nms, INSTR('/'||nms,'/',1,7)
     , INSTR(nms||'/','/',1,7)-INSTR('/'||nms,'/',1,7)) nm7
     , SUBSTR(nms, INSTR('/'||nms,'/',1,8)
     , INSTR(nms||'/','/',1,8)-INSTR('/'||nms,'/',1,8)) nm8
     , dt, qty
  FROM (SELECT rn, lv
             , chl_id, par_id, nm
             , (SELECT MIN(DECODE(a.lv - LEVEL, 0, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 1, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 2, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 3, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 4, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 5, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 6, nm))
               ||'/'|| MIN(DECODE(a.lv - LEVEL, 7, nm)) nm
                  FROM tr1 b
                 START WITH chl_id = a.chl_id
                 CONNECT BY chl_id = PRIOR par_id
                ) nms
             , DECODE(chl_id
               , LEAD(par_id) OVER(ORDER BY rn), 0, 1) is_leaf
          FROM (SELECT ROWNUM rn
                     , LEVEL lv
                     , chl_id, par_id, nm
                  FROM tr1
                 START WITH par_id = 0
                 CONNECT BY PRIOR chl_id = par_id
                ) a
        ) a
     , tr b
 WHERE a.is_leaf = 1
   AND a.chl_id = b.cd(+)
 ORDER BY rn, dt
;

두분 모두 감사합니다. 마농님 덕분에 해결했습니다.