외래키 검색

select a.table_name, a.constraint_name, c.column_name 
from user_constraints a, user_constraints b, user_cons_columns c
where a.r_constraint_name = b.constraint_name
and b.table_name = '<원하는 table명>'
and c.constraint_name = b.constraint_name