Oracle擷取下級節點

標籤：io   ar   strong   on   art   as   sql   oracle   c   

oracle ：
尋找所有下級
　　select * from tbl_test start with id=1 connect by prior id=pid
尋找所有上級
select * from tbl_test start with id=5 connect by prior pid=id

sql server：

sql server 遞迴擷取下級和當前級
with cte as
(
select OrgCode,OrgParentCode, 0 as lvl from SysOrgan
where OrgCode = ‘zfj‘
union all
select d.OrgCode,d.OrgParentCode,lvl + 1 from cte c inner join SysOrgan d
on c.OrgCode = d.OrgParentCode
)
select * from cte

Oracle擷取下級節點