title: Viewing oracle's metadata about primary/foreign key constraints
body: <p>Which table contains detailed information(For example the table the foreign key is referring to)  about the constraints? The tables 'all_cons_columns' , 'all_constraints' contains only the name of the constraints which isn't very helpful.
  I am currently using dbms_metadata.get_ddl() but it doesn't work on all the databases.</p>
  
  <p>Thanks.</p>