Commit After Performing Insert or Update or Delete Operation For Every X Records

Commit After Performing Insert or Update or Delete Operation For Every X Records

 

Following query can be used to commit the database after performing update or delete operation for every 1000 rows in loop.Place the below code in the procedures.

if mod(i, 1000)
commit;
dbms_output.put_line('Commit issued for rows up to: 'c1%rowcount);
end if;