一個查詢樹狀結構的語句
SELECT 1,LEVEL,LNAME,NULL,CODE
FROM PRDGP CONNECT BY PRIOR CODE = P_CODE
START WITH P_CODE IS NULL
說明：P_CODE為父級，CODE為子集，P_CODE為空時為樹的最頂級，即為Start with 起點，遞歸方式為CODE = P_CODE,LEVEL為樹的等級
SELECT CODE,LNAME,CNAME
FROM PRDGP WHERE CODE <> 'LBL' AND TYPE= 'GMT' CONNECT BY PRIOR CODE=PARENTGRP AND PARENTGRP <> 'LBL'
START WITH PARENTGRP IS NULL ORDER BY CODE
posted on 2008-12-10 15:56
譚明 閱讀(389)
評論(0) 編輯 收藏 所屬分類:
Oracle