How can the starting value of a sequence be modified in Oracle?

11 months ago

Jackson Davis

1 minute

To change the starting value of a Sequence in an Oracle database, you can use the ALTER SEQUENCE statement. Here is an example:

ALTER SEQUENCE sequence_name
START WITH new_start_value;

sequence_name is the name of the Sequence to be modified, while new_start_value is the new starting value to be set.

For example, if you want to change the starting value of a Sequence named my_sequence to 1000, you can execute the following statement:

ALTER SEQUENCE my_sequence
START WITH 1000;