//SQL中查询树结构式结果
SQL:Select A.ID,A.GNWZMC,A.idx,B.idx As ParentIdx,A.级数
From (Select Rownum As Idx,Level As 级数,ID,FID,GNWZMC
From GY_SB_WJJG
Start With FID='-1' Connect By Prior ID=FID) A,
(Select Rownum As Idx,ID
From GY_SB_WJJG
Start With FID='-1' Connect By Prior ID=FID) B
Where A.FID=B.ID
Order By A.idx
//当然可以用start with