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!

Get the Table name by providing the Sequence name

424670May 4 2005 — edited May 4 2005

Hello,

I wish to retrieve the table name to which the sequence is related.

I understand that when the sequence was created, no reference is mentioned to any table. The sequence may be used across many tables.

But the DB definitely knows internally how many tables are referencing the particular sequence.

So, can anyone help me in finding the table (or all tables) referencing one particular sequence.

Thanks and Regards

(Please treat this as urgent as i am desperately in need of such a query)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2005

Added on May 4 2005

6 comments

740 views