CURSOR cur_tbl_n_txn_wk IS
SELECT ...... ;
TYPE type_array_tnt IS TABLE OF cur_tbl_n_txn_wk%ROWTYPE INDEX BY BINARY_INTEGER;
v_tbl_n_txn_wk type_array_tnt;
--批量每次fetch数量
v_rows NUMBER := 100;
begin
OPEN cur_tbl_n_txn_wk;
LOOP
FETCH cur_tbl_n_txn_wk BULK COLLECT
INTO v_tbl_n_txn_wk LIMIT v_rows;
FORALL i IN 1 .. v_tbl_n_txn_wk.count
INSERT INTO tbl_dc_trade_water(......)
VALUES
(v_tbl_n_txn_wk(i).tdtw_id......);
COMMIT;
EXIT WHEN cur_tbl_n_txn_wk%NOTFOUND;
END LOOP;
CLOSE cur_tbl_n_txn_wk;
COMMIT;
end;
SELECT ...... ;
TYPE type_array_tnt IS TABLE OF cur_tbl_n_txn_wk%ROWTYPE INDEX BY BINARY_INTEGER;
v_tbl_n_txn_wk type_array_tnt;
--批量每次fetch数量
v_rows NUMBER := 100;
begin
OPEN cur_tbl_n_txn_wk;
LOOP
FETCH cur_tbl_n_txn_wk BULK COLLECT
INTO v_tbl_n_txn_wk LIMIT v_rows;
FORALL i IN 1 .. v_tbl_n_txn_wk.count
INSERT INTO tbl_dc_trade_water(......)
VALUES
(v_tbl_n_txn_wk(i).tdtw_id......);
COMMIT;
EXIT WHEN cur_tbl_n_txn_wk%NOTFOUND;
END LOOP;
CLOSE cur_tbl_n_txn_wk;
COMMIT;
end;