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 find out particular sequences is used to particular table

kn_sivaramanSep 8 2011 — edited Dec 14 2011

Hi,

i have more than 10 sequences and more than 100 tables.The sequence name like seq_emp_no,seq_empno,seq_emp_id and table name like emp1,emp2,employee,employer.The sequence details we will get from all_sequences data dictionary and table details we will get from all_tables data dictionary.

Is any other data dictionary tables is there in Oracle database(like user,all,dba......tables,sequences) find out the particular sequence is used for particular tables?

How to find out the particular sequence is used for particular tables?.

Thanks
N.Sivaraman

Edited by: kn_sivaraman on Sep 8, 2011 3:24 AM

Edited by: kn_sivaraman on Sep 8, 2011 3:24 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2012

Added on Sep 8 2011

5 comments

6,972 views