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!

give the sequence name whose last id value

user575089Dec 30 2009 — edited Dec 30 2009

I need a sql query which will give the sequence name whose last id value is '20461'

The reason I need this is :
I have loads of sequences and I'm lost in them . So, I am planning to get the required sequence name by running a sql query.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2010

Added on Dec 30 2009

#general-database-discussions

15 comments

1,926 views