Skip to content

Instantly share code, notes, and snippets.

@xymor
Created August 7, 2012 15:28
Show Gist options
  • Save xymor/3286394 to your computer and use it in GitHub Desktop.
Save xymor/3286394 to your computer and use it in GitHub Desktop.
advance a sequence without ddl permissions
-- pardon my noob plsql skills
declare
val number;
begin
for i in 1..100 loop
select B2B_B2W_ADMIN.STOCKDETAIL_SEQ.nextval into val from dual;
end loop;
end;
-- remember to commit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment