sql - Oracle - 以树格式查找所有外键依赖项的脚本？

Question

我需要一些以树格式返回所有外键依赖项的脚本。

我找到了这个，但不是树格式：

SELECT c.owner, c.table_name, c.constraint_name, level
FROM dba_constraints r, dba_constraints c
WHERE r.owner = c.r_owner
AND r.constraint_name = c.r_constraint_name
START WITH r.owner = 'OWNER_HERE' AND r.table_name = 'TABLE_HERE'
CONNECT BY NOCYCLE r.owner = PRIOR c.owner
AND r.table_name = PRIOR c.table_name
ORDER BY level;

有没有办法以树格式返回它？

标签： sqloracle