web analytics

How to change start value of a sequence in Oracle?

Options

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.

Comments

You must Sign In to comment on this topic.


© 2022 Digcode.com