Oracle data migration to History table data ———— procedure

Create or replace procedure Remove_refund_his_pro is
Begin
Declare
Cursor Refund_query_cur is
Select rowID from Ucmp_realtime_refund_query t1
where t1.apply_tm<= TRUNC (Add_months (Sysdate,-3), ' DD ') and ROWNUM <= ' 100000000 ';
TYPE Rowid_table_type is table of ROWID index by Pls_integer;
V_rowid Rowid_table_type;
Begin
Open refund_query_cur;
Loop
Fetch refund_query_cur Bulk collect into V_rowid limit 100000;
Exit when v_rowid.count=0;
ForAll i in V_rowid.first. V_rowid.last
INSERT into His_realtime_refund_query
(SELECT * from Ucmp_realtime_refund_query
WHERE rowID = V_rowid (i));
ForAll J in V_rowid.first. V_rowid.last
DELETE from Ucmp_realtime_refund_query
WHERE rowID = V_rowid (j);
Commit
End Loop;
Close refund_query_cur;
End
End Remove_refund_his_pro;

Oracle data migration to History table data ———— procedure