So I am trying to figure out how to write a query in Oracle where I can find where a table is being used in a foreign key constraint
For example if I look in SQL Developer at a specific table I can get the table details by hitting SHIFT-F4 or just clicking on the table and I get the following view
So I can see the constraint name is "VAAWARDFUNDING_VAWARD" and its a foreign key constraint using the table "VALID_AWARD_FUNDING".
Now lets say I want to see where else is "VALID_AWARD_FUNDING" is being used as a foreign key constraint - Where can I go to find this?
I tried looking in ALL_CONSTRAINTS but it only pulls up the constraints on the table itself and doesnt show related table info.
I also took a look at the ALL_DEPENDANCIES table but it doesnt seem to show constraints.
Is there another Oracle view/table that would show the constraint AND also the related table used in the constraint?
Hopefully that makes sense
TIA
