Skip to Main Content

Oracle Database Discussions

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!

current value of a sequence

407048Feb 7 2006 — edited Feb 8 2006
Is there a way to get the current value of a sequence (other than saying a
select seq.nextval from dual and then, select seq.currval from dual). I just didn't want to bump up the sequence by saying nextval but needed to find the current value.

My sequence was created with options cache 20 , increment by 1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2006
Added on Feb 7 2006
12 comments
146,717 views