oracle递归查询

查询的表复合递归查询条件,父节点,子节点 table tree

SELECT * FROM tree START WITH id = 2 CONNECT BY PRIOR pid = id -- 递归查询父节点  
union  
SELECT * FROM tree START WITH id = 2 CONNECT BY pid = PRIOR id; -- 递归查询子节点  

 

posted @ 2017-04-15 13:03  挖坑大王  阅读(271)  评论(0编辑  收藏  举报