web analytics

How to change start value of a sequence in Oracle?

Options

codeling 1595 - 6639
@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.


© 2024 Digcode.com