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 get all sequence value from all table in schema/user

karmayaDec 3 2012 — edited Dec 3 2012

Hi,

I am using oracle 11g database. i have nearly 100 table. I want to know All sequence Current value("Currval")
of all tables in particular schema/user

Please help me how can i get this using Query

thanks in Advance
karmaya

This post has been answered by jeneesh on Dec 3 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2012

Added on Dec 3 2012

#plsql

4 comments

2,062 views