Friday, March 9, 2012

Doing commits after n number of rows

If a certain table has lets say a million rows and you want to perform updates on each of the row in the table without overloading 'undo tablespace' then one option could be by doing the commits after every 'n' number of rows.below is the procedure that takes 'n' as a parameter . This will let oracle to perform commits after 'n' rows are updated