在树形展开应用中,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;
该代码还提供了如何进行多对多关系的表单查询