SELECT DISTINCT(CTN_ID) FROM KM_CTN
CONNECT BY PRIOR CTN_ID = CTN_PARENT START WITH CTN_ID IN (SELECT
CTN_ID FROM KM_CM WHERE CM_USR_ID = 'admin')
위에게 오라클 커리 문인데
밖으로 나와잇는데 connect by 는 어찌 해결하겟는데 안에 잇는걸
어찌 해야할지...ㅠㅠ
with ctn(DISTINCT ctn_id,CTN_PARENT ) as
(
SELECT DISTINCT ROOT.CTN_ID,ROOT.CTN_PARENT
FROM KM_CTN ROOT
WHERE CTN_ID in (SELECT CTN_ID FROM KM_CM WHERE CM_USR_ID =
'admin')
UNION ALL
SELECT DISTINCT SUB.CTN_ID,SUB.CTN_PARENT
FROM KM_CTN SUB, CTN SUPER
WEHRE SUB.CTN_ID = SUPER.CTN_ID
)
SELECT * FROM CTN
with ctn(DISTINCT (ctn_id),CTN_PARENT ) as
(
SELECT DISTINCT (ROOT.CTN_ID),ROOT.CTN_PARENT
FROM KM_CTN ROOT
UNION ALL
SELECT DISTINCT SUB.CTN_ID,SUB.CTN_PARENT
FROM KM_CTN SUB, CTN SUPER
WEHRE SUB.ctn_parent = SUPER.CTN_ID
)
SELECT * FROM ctn WHERE CTN_ID in (SELECT CTN_ID FROM KM_CM WHERE
CM_USR_ID = 'admin')
나름데로 요렇게 해봣느데 계속 에러 메세지만...ㅠㅠ
아~왜~ 안돼는거야...ㅠㅠ
|