oracle外键查询

查询外键

 select c.constraint_name,  
        c.table_name,  
        c.constraint_type,  
        c.r_constraint_name  
   from user_constraints c  
 where c.r_constraint_name = 'PK_ZYY_USER'  
   and c.constraint_type = 'R' 

 或者

select * from user_cons_columns t where t.constraint_name like