Set Oracle Sequence Start Value

1 year ago
William Carter
1 minute

To set the initial value of an auto-increment sequence in Oracle, you can use the ALTER SEQUENCE statement to modify the starting value of the sequence. Here is an example:

ALTER SEQUENCE sequence_name START WITH new_initial_value;

Here, sequence_name refers to the name of the sequence to be modified, and new_initial_value is the new initial value to be set. By executing the above SQL statement, you can modify the starting value of the sequence to the specified value.

bannerAds