Sponsored Links
How do we set the LASTVALUE value in an Oracle Sequence
Question: How do we set the LASTVALUE value in an Oracle Sequence?
Answer: You can change the LASTVALUE for an Oracle sequence, by executing an ALTER SEQUENCE command.
For
example, if the last value used by the Oracle sequence was 100 and you
would like to reset the sequence to serve 225 as the next value. You
would execute the following commands.
alter sequence seq_name
increment by 124;
select seq_name.nextval from dual;
alter sequence seq_name
increment by 1;
Now, the next value to be served by the sequence will be 225.
Page 1
|
| 
