title: Using sql to find which lookup tables are linked to table fields?
body: <p>I have a table Entity. This table references various look up tables. For example the field 'ethnicity_code' in the entity table references a look up table called 'lkp_race'. Now it is not too difficult to figure out that race and ethnicity are connected, but in toher instances the connection is not so clear. I would like to be able to know which of the 'lkp_' tables are referenced from other tables like entity. Is there a way to use Oracle pl sql to write a query to say something like the following: </p>
  
  <p>If tablename LIKE 'lkp_%' then what are the tables that link to these tables and on what fields are they linked by?</p>
  
  <p>Does that make sense?</p>