Infolinks

Thursday 21 June 2012

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;

No comments:

Post a Comment