Modifying a Sequence

You modify a sequence using the ALTER SEQUENCE statement. You cannot change the start value of a sequence. The minimum value cannot be more than the current value of the sequence. The maximum value cannot be less than the current value of the sequence. The following example modifies my_seq to increment the sequence of numbers by 2:

SQL> ALTER SEQUENCE my_seq
  2  INCREMENT BY 2;

Sequence altered.

SQL>

1. Creating a Sequence
2. Retrieving Information on Sequences
3. Using a Sequence
4. Populating a Primary Key Using a Sequence
5. Modifying a Sequence
6. Using Sequences in PL/SQL
7. Dropping a Sequence