A simple script to increment Oracle sequences.
set serveroutput on
declare
x integer;
begin
x:=89796633;
while x < 89796703 loop
select mysequence.nextval into x from dual;
dbms_output.put_line(x);
end loop;
end;
/
Tuesday, October 12, 2010
Subscribe to:
Post Comments (Atom)
1 comments:
You may be interested in the following article:
Resetting Sequences
Post a Comment