web analytics

How to change start value of a sequence in Oracle?


codeling 1573 - 6555
@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.


You must Sign In to comment on this topic.

© 2022 Digcode.com