Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set Sequence current value?

659873Sep 24 2008 — edited Sep 26 2008
Hi,

I would like to force the MySEQ sequence to a precise value, so that the next time, when MySEC.nextval is called, it will be 165. The increment, cache options, etc. remain unchanged. So if the increment was 1, then afterward, this sequence will deliver 166, 167, etc.

Thanks in advance for any help.
This post has been answered by SamB on Sep 25 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2008
Added on Sep 24 2008
8 comments
34,608 views