oracle 查询所有引用某主键的外联表

--表名

select * from user_constraints e where e.table_name = '';

 

 

 

--主键约束名称

select b.table_name,b.column_name from user_constraints a

inner join user_cons_columns b on a.CONSTRAINT_NAME = b.CONSTRAINT_NAME

where a.R_CONSTRAINT_NAME = '';