set verify off feed off
break on chave_pai skip 1
SELECT p.constraint_name chave_pai, r.table_name tabela_dependente, r.constraint_name chave_dependente
FROM dba_constraints p, dba_constraints r
WHERE p.owner=r.r_owner
and p.constraint_name = r.r_constraint_name
and p.owner like upper('&1')
and p.table_name like upper('&2')
ORDER BY 1
/
undefine 1
undefine 2
clear break
set verify on feed on