How to change start value of a sequence in Oracle? Options

codeling Posts: 1055 Points: 4434
Posted: Wednesday, January 30, 2019 9:16:20 AM

You can use the following statement to change the value of a sequence without recreating it.

ALTER SEQUENCE dev.my_sequence INCREMENT BY 500;

The start value of the sequence will be increased by 500.

Users browsing this topic