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!

user_sequences - last number and nextval without using nextval

user5716448May 23 2014 — edited May 23 2014

Hi,

Using oracle 11.20.3

Is there anyway to see what next number would be - notice is last_number in user_sequences and in theory would expect next number to be this + 1 just wondered if stored anywhere.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 20 2014

Added on May 23 2014

#general-database-discussions

8 comments

3,844 views