select
A.TABLE_NAME as “外键所在表”,
A.CONSTRAINT_NAME as “外键名称” ,
c.column_name as “外键所在列”,
B.TABLE_NAME AS “引用表” ,
B.COLUMN_NAME AS “引用列”
from
DBA_CONSTRAINTS A ,
DBA_CONS_COLUMNS B,
dba_cons_columns c
WHERE
A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME
and a.CONSTRAINT_NAME = c.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE =‘R’;