-- CREATED ON 2021/4/21
DECLARE
-- LOCAL VARIABLES HERE
I INTEGER;
CURSOR C_CUR IS
SELECT * FROM PO_LT_REPORT_ALL;
TYPE ALL_MAR_LIST IS TABLE OF C_CUR%ROWTYPE INDEX BY BINARY_INTEGER;
AML_S ALL_MAR_LIST;
PROCEDURE INSERT_DATE (AML_S IN ALL_MAR_LIST)--定義一個子函式
IS
BEGIN
FOR I IN 1..AML_S.COUNT LOOP
INSERT INTO PO_LT_REPORT_ALL(MITAC_PN,ITEM_DESC) VALUES(AML_S(I).MITAC_PN,AML_S(I).ITEM_DESC);
END LOOP;
COMMIT;
END INSERT_DATE;
BEGIN
-- TEST STATEMENTS HERE
--FOR C1 IN C_CUR LOOP
--獲取所有資料
OPEN C_CUR;
FETCH C_CUR BULK COLLECT INTO AML_S;
CLOSE C_CUR;
INSERT_DATE(AML_S);
--END LOOP;
END;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/278603.html
標籤：基礎和管理