Skip to content

Instantly share code, notes, and snippets.

@aleguerra05

aleguerra05/setOracleSequences.sql

Last active April 21, 2021 20:44
Show Gist options
  • Save aleguerra05/5aa139745f981166126435ce0f1c7d53 to your computer and use it in GitHub Desktop.
Save aleguerra05/5aa139745f981166126435ce0f1c7d53 to your computer and use it in GitHub Desktop.
Download ZIP
Set value of all sequences of oracle schema
Raw
setOracleSequences.sql
BEGIN
FOR x in (select * from user_sequences)
LOOP
EXECUTE IMMEDIATE 'drop sequence '||x.sequence_name ;
EXECUTE IMMEDIATE 'create sequence '||x.sequence_name||' start with 10000';
END LOOP;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment