WITH TBL AS(
SELECT '1000' CODE,'기아'   NAME,'0000' UP_CODE FROM DUAL UNION ALL
SELECT '1100' CODE,'중형'   NAME,'1000' UP_CODE FROM DUAL UNION ALL
SELECT '1101' CODE,'쏘렌토' NAME,'1100' UP_CODE FROM DUAL UNION ALL
SELECT '1102' CODE,'K5'     NAME,'1100' UP_CODE FROM DUAL UNION ALL
SELECT '1200' CODE,'대형'   NAME,'1000' UP_CODE FROM DUAL UNION ALL
SELECT '1201' CODE,'K9'     NAME,'1200' UP_CODE FROM DUAL UNION ALL
SELECT '1202' CODE,'카니발' NAME,'1200' UP_CODE FROM DUAL
)

SELECT SUBSTR(CONN_NAME,2) CONN_NAME
FROM (
    SELECT SYS_CONNECT_BY_PATH(NAME,'-') CONN_NAME
          ,CONNECT_BY_ISLEAF ISLEAF
    FROM TBL
    START WITH UP_CODE = '0000'
    CONNECT BY NOCYCLE UP_CODE = PRIOR CODE
    )
WHERE ISLEAF = 1

정말 감사합니다만,

하나의 열이 아닙니다. - 는 각 열을 구분하기 위해 추가한 건데.. ㅠㅠ

그러니까 기아, 중형, 쏘렌토 이렇게 세개의 컬럼이 나와야 합니다.

다시 부탁드립니다. ^^;;

SELECT REGEXP_SUBSTR(CONN_NAME,'[^\]+',1,1) NAME_1
      ,REGEXP_SUBSTR(CONN_NAME,'[^\]+',1,2) NAME_2
      ,REGEXP_SUBSTR(CONN_NAME,'[^\]+',1,3) NAME_3
      ,REGEXP_SUBSTR(CONN_NAME,'[^\]+',1,4) NAME_4
FROM (
    SELECT SUBSTR(SYS_CONNECT_BY_PATH(NAME,'\'),2) CONN_NAME
          ,CONNECT_BY_ISLEAF ISLEAF
    FROM TBL
    START WITH UP_CODE = '0000'
    CONNECT BY NOCYCLE UP_CODE = PRIOR CODE
    )
WHERE ISLEAF = 1

정말로 감사드립니다.

많은 도움이 되었습니다. 꾸벅~~ (__)(^^)