constraints
sir ,how can we find tables those which are related each other exactly(while training) not apps tables ,simply in 9i db environment(user defined tables)
Software/Hardware used:
Software/Hardware used:
ASKED:
October 4, 2007 1:15 PM
UPDATED:
September 16, 2008 9:57 PM
Answer Wiki:
I'm not sure if I understand correctly, but the all_constraints table can be used to get the table relations.
This is an example query:
<pre>select ac.constraint_name,ac.table_name child_table,ac2.table_name parent_table
from all_constraints ac,all_constraints ac2
where ac.r_constraint_name = ac2.constraint_name;</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
