› Fóruns › SQL e PL/SQL › Duvidas Iniciante › Duvidas Iniciante
19 de janeiro de 2007 às 2:19 pm
#78505
Participante
Select a.owner, a.table_name, a.constraint_name, b.owner, b.table_name, b.constraint_name
From dba_constraints a, dba_constraints b
Where a.r_constraint_name = b.constraint_name
and a.constraint_type = ‘R’
and b.owner = ”
and b.table_name=”
Order by a.owner, a.table_name