System and Application Softwares
How to change start value of a sequence in Oracle?
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.
© 2020 Digcode.com. All rights reserved.