oracle 递归查询 查询当前选中节点的所有子节点

在树形展开应用中，oracle 提供了快捷了展开

View Code

PROCEDURE Get_Employee_By_Org_Info_Id(In_Org_Info_Id IN Number ,
List_Cur OUT t_Cur) As
BEGIN
OPEN List_Cur FOR
SELECT *
FROM Employee
WHERE employee.employee_id In
( SELECT org_emp.employee_id
FROM Org_Emp
WHERE org_emp.org_info_id in ( select org_info.org_info_id from org_info connect by prior org_info.org_info_id = org_info.parent_org_info_id start with org_info.org_info_id = In_Org_Info_Id));
end ;

该代码还提供了如何进行多对多关系的表单查询

转载于:https://www.cnblogs.com/zuifengke/archive/2011/06/13/2079881.html