主外鍵約束信息

　　Ｃｏｐｙ　ｆｒｏｍ　The Oracle (tm) Users CoOperative FAQ

　　 Parent / Child / Key Reference

　　set pages
set feedback off
spool constraintlog

　　col parent format a
col child  format a
col key    format a

　　select atable_name         Parent
       btable_name         Child
       column_name          Key
       substr(position) P
from
      user_constraints a user_constraints b user_cons_columns c
where
      nstraint_name = br_constraint_name
and   nstraint_name = nstraint_name
order by ;

　　spool off

From:http://tw.wingwit.com/Article/program/Oracle/201311/18360.html