Your Ad Here

advanced code snippet search

Posted By

indianocean on 05/15/09


Tagged

sql Oracle PLSQL


Versions (?)

Increase sequence

 / Published in: SQL
 

usefull if you don't have the permission to directly alter the procedure

Expand | Embed | Plain Text 
  1. DECLARE
  2.   l_var   PLS_INTEGER;
  3.     BEGIN
  4.       FOR i IN 1 .. 500
  5.        LOOP
  6.          SELECT myseq.NEXTVAL INTO l_var FROM DUAL;
  7.        END LOOP;
  8. END;

Report this snippet  

You need to login to post a comment.