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