查询一个机构下所辖机构:
select * from t00_organ t start with t.organkey=#uporgankey# connect by prior t.organkey=t.uporgankey ;
查询一个机构下所辖机构:
select * from t00_organ t start with t.organkey=#uporgankey# connect by prior t.organkey=t.uporgankey ;
转载于:https://www.cnblogs.com/liudi1992/p/5948047.html