반응형

select c.constraint_name as "foreign key", p.constraint_name as "referenced key", p.constraint_type, p.owner, p.table_name
from dba_constraints c, dba_constraints p
where c.owner = '&OWNER'
and c.table_name = '&TABLE_NAME'
and c.constraint_type = 'R'
and c.r_owner = p.owner
and c.r_constraint_name = p.constraint_name;

+ Recent posts