mysql递归树需要用到函数完成,而oracle的递归却显的简单了,一条sql就可以解决了
- 递归父节点
select * from rr s start with s."ID"=584 CONNECT by s.id= PRIOR s.PARENT_ID
- 递归子节点
select * from rr s start with s."ID"=584 CONNECT by PRIOR s.id= s.PARENT_ID
大家发现没,其实prior在子节点这边,即遍历子节点,在父节点这边即遍历父节点