Skip to content

Instantly share code, notes, and snippets.

@thalysonalexr

thalysonalexr/alter-start-sequence.sql

Created January 21, 2023 16:17
Show Gist options
  • Save thalysonalexr/88d62935446b00cd8978140d1bd54f0f to your computer and use it in GitHub Desktop.
Save thalysonalexr/88d62935446b00cd8978140d1bd54f0f to your computer and use it in GitHub Desktop.
Download ZIP
Change initial sequence to last value of Oracle table
Raw
alter-start-sequence.sql
ALTER TABLE ROLES MODIFY ID GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH LIMIT VALUE);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment