CONNECT_BY_ISCYCLE 썸네일형 리스트형 [ORACLE]CONNECT_BY_ISCYCLE CONNECT_BY_ISCYCLE CONNECT BY 중복참조를 체크해주는 함수CONNECT BY NOCYCLE 를 사용할 경우에만 사용가능 중복참조의 경우 "ORA-01436 CONNECT BY의 루프가 발생되었습니다." 발생 - 정상적인 CONNECT BY WITH CV_MST AS ( SELECT '0001' AS P_ITEM_NO, '0003' AS C_ITEM_NO, 'PARENT' AS ITEM_NM FROM DUAL UNION ALL SELECT '0003' AS P_ITEM_NO, '0005' AS C_ITEM_NO, 'CHILD1' AS ITEM_NM FROM DUAL UNION ALL SELECT '0003' AS P_ITEM_NO, '0006' AS C_ITEM_NO, 'CHILD2'.. 더보기 이전 1 다음