[Oracle]Oracle中查询该表中的主键被哪些表引用，该表中的外键来源于哪些表

Oracle中查询该表中的主键被哪些表引用的SQL语句：

select c.TABLE_NAME  
  from all_constraints p, all_constraints c  
 where p.table_name = '表名'  
   and p.OWNER = SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')  
   and c.OWNER=SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')  
   and c.constraint_type = 'R'  
   and p.CONSTRAINT_NAME = c.R_CONSTRAINT_NAME   

Oracle中查询该表中的外键来源于哪些表的SQL语句：

select cl.table_name  
  from user_cons_columns cl  
  left join user_constraints c  
    on cl.constraint_name = c.r_constraint_name  
 where c.constraint_type = 'R'  
   and c.table_name = '表名'  

Oracle中查询该表被哪些表引用的SQL语句

select c.table_name,
        c.constraint_name,
        fc.table_name,
        fc.constraint_name,
        cc.column_name,
        fcc.column_name
   from user_cons_columns fcc,
        user_cons_columns cc,
        user_constraints  c,
        user_constraints  fc
  where fc.constraint_name = c.r_constraint_name
    and fc.constraint_name = fcc.constraint_name
    and c.constraint_name = cc.constraint_name
    and c.constraint_type = 'R'
and  fc.table_name in ('表名') ;

PS：查询owner的SQL语句： select SYS_CONTEXT(‘USERENV’, ‘CURRENT_SCHEMA’) from dual