PPT Slide
When the sequence is re-created, you
may need to set the first value produced
by the sequence in order to avoid
primary-key constraint violations.
Any parameter of a sequence can be
modified by issuing the alter sequence
ALTER SEQUENCE countdown_20 INCREMENT BY 4;
The effect is immediate—the statement
will change the COUNTDOWN_20 to
decrement each NEXTVAL by 4.