Oracle PL/SQL Tutorial/Sequences/Modify Sequence

Modifying a Sequence

1. You modify a sequence using the ALTER SEQUENCE statement.
2. You cannot change the start value of a sequence.
3. The minimum value cannot be more than the current value of the sequence ( currval ).
4. The maximum value cannot be less than the current value of the sequence ( currval ).

5. 3. Modify Sequence 5. 3. 1. Modifying a Sequence