Oracle递归sql笔记

查询一个机构下所辖机构：

select * from t00_organ t start with t.organkey=#uporgankey# connect by prior t.organkey=t.uporgankey ;