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

codeling 1262 - 5391
@2019-01-30 09:16:20

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