直接在oracle 递归查询语句
select * from groups start with id=:DeptId connect by prior superiorid =id
往下找
select * from groups start with id=:DeptId connect by prior id=superiorid
直接在oracle 递归查询语句
select * from groups start with id=:DeptId connect by prior superiorid =id
往下找
select * from groups start with id=:DeptId connect by prior id=superiorid
作者:zscmj
出处:http://www.cnblogs.com/zscmj/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。