select nivel, parent_table_name, child_table_name, fkey_constraint
from ( select max(level) nivel,
parent_table_name,
child_table_name,
fkey_constraint
from ( select pk.table_name parent_table_name,
pk.constraint_name pkey_constraint,
fk.table_name child_table_name,
fk.constraint_name fkey_constraint,
fk.r_constraint_name
from all_constraints pk,
all_constraints fk
where pk.constraint_name = fk.r_constraint_name
and pk.constraint_type in ('P','U')
and fk.status = 'ENABLED'
and fk.constraint_type = 'R'
)
start with parent_table_name = upper('&TABELA')
connect by nocycle prior child_table_name = parent_table_name
group by parent_table_name, child_table_name, fkey_constraint
)
order by nivel
/
Nenhum comentário:
Postar um comentário