How to Alter Sequence

Altering a sequence can be useful when you want to change the next value of the sequence, however in Oracle it is not possible to do it with a single alter sequence command. To change the next value of an existing sequence to a different number, you have to drop and recreate it as follows:

drop sequence emp_seq_id;

Create sequence emp_seq_id start with 10100;