How do I update the sequence value?
Situation: I'm going to create a sequence but this table may be either registered or unconfigured. So how do I generate the sequence 0 or so with value since there is already a record?
create sequence S_SEG_EXE;
How do I update the sequence value?
Situation: I'm going to create a sequence but this table may be either registered or unconfigured. So how do I generate the sequence 0 or so with value since there is already a record?
create sequence S_SEG_EXE;
You can use ALTER SEQUENCE
:
ALTER SEQUENCE S_SEG_EXE INCREMENT BY 100;
In the example above, the current value of the sequence has been increased by 100. The value can be negative also if you want to reduce the value.