Skip to content

Instantly share code, notes, and snippets.

@Tracnac

Tracnac/Alterer une séquence sans la supprimer.md

Last active October 19, 2022 11:59
Show Gist options
  • Save Tracnac/6e2c7699a2810e97029cd593d0233c79 to your computer and use it in GitHub Desktop.
Save Tracnac/6e2c7699a2810e97029cd593d0233c79 to your computer and use it in GitHub Desktop.
Download ZIP
Alterer une séquence sans la supprimer #oracle #sql
Raw
Alterer une séquence sans la supprimer.md 
alter sequence seq increment by (desired_value-current_value);
select seq.nextval from dual;
alter sequence seq increment by (old_increment);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment