How to Alter Sequence

Alter a sequence can be useful when you want to alter the next value of the sequence. The SQL statement to use is:

alter sequence emp_seq_id restart 10100;

IN THIS PAGE