-- =======================================================================
--	As tabelas que utilizam uma constraint(PK ou UK) de uma tabela pai
-- =======================================================================
set verify off

select OWNER, 
       CONSTRAINT_NAME, 
       CONSTRAINT_TYPE, 
       TABLE_NAME, 
       R_OWNER, 
       R_CONSTRAINT_NAME
from dba_constraints
where R_CONSTRAINT_NAME = upper('&1')
/

set verify on