connect by (2) 썸네일형 리스트형 START WITH ~ CONNECT BY ~ 에서 말단 Leaf Start With ~ Connect By ~ 를 어느정도 사용 하다보니 나오는 데이터의 Tree 구조에서 Leaf 를 찾아야 하는 하는 경우가 있었다. 10g 이상에서는 CONNECT_BY_ROOT SYS_CONNECT_BY_PATHCONNECT_BY_ISLEAF 라는 것을 제공하여 SELECT LPAD(LEVEL, LEVEL*3) AS TREE, A.* , CONNECT_BY_ISLEAF AS IsLeaf FROM TreeTable A START WITH A.PCODE = '@'AND USEFLAG = '1' CONNECT BY A.PCODE = PRIOR A.CODE AND USEFLAG = '1' ORDER SIBLINGS BY DISPSEQ ASC CONNECT_BY_ISLEAF 를 통해서 1 .. Oracle 계층적 트리구조 START WITH ~ CONNECT BY ~ ORDER SIBLINGS BY > TreeTable > SELECT LPAD(LEVEL, LEVEL*3) AS TREE, A.* FROM TreeTable A START WITH A.PCODE = '@'AND USEFLAG = '1' CONNECT BY A.PCODE = PRIOR A.CODE AND USEFLAG = '1' ORDER SIBLINGS BY DISPSEQ ASC > Result 이전 1 다음
