Quick Search:
 
 Oracle PL/SQL: Periodic COMMIT loop Jump to:  
Category: >> Oracle PL/SQL >> Periodic COMMIT loop  

<< lastnext >>

Snippet Name: Periodic COMMIT loop

Description: Updating via simple loop, doing a commit every X number of records.

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

DECLARE
  i NUMBER := 0;
  CURSOR G1 IS SELECT * FROM sometable WHERE col1 = 'somevalue'
               FOR UPDATE;
BEGIN
  FOR c1 IN S1 LOOP
      UPDATE tab1 SET col1 = 'somevalue1'
             WHERE CURRENT OF G1;
 
      i := i + 1;              -- Commits after every X number of records
      IF i > 1000 THEN
         COMMIT;
         i := 0;
      END IF;
 
  END LOOP;
  COMMIT;
END;


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org