ORACLE 嵌套游标
DECLARE C1 SYS_REFCURSOR;BEGIN
OPEN C1 FOR
SELECT Msi.Organization_Id,
Msi.Inventory_Item_Id,
Msi.Segment1,
CURSOR (SELECT Ood.Organization_Id,
Ood.Organization_Code,
Ood.Organization_Name
FROM Org_Organization_Definitions Ood
WHERE Ood.Organization_Id = Msi.Organization_Id)
FROM Mtl_System_Items_b Msi;
END;
页:
[1]