SELECT lpad(NAME, 7 * (level), '-') ||
decode(level, 1, '+', 2, ' ', 3, '|', 4, '*', ''),
TYPE,
REFERENCED_NAME,
REFERENCED_TYPE,
LEVEL
FROM dba_dependencies
where REFERENCED_OWNER <> 'SYS'
AND TYPE NOT IN ('TABLE', 'VIEW')
AND REFERENCED_TYPE NOT IN ('TABLE', 'VIEW')
START WITH NAME = '&1'
CONNECT BY nocycle PRIOR REFERENCED_NAME = NAME;
查询代码之间的依赖关系(从root开始)
最新推荐文章于 2023-06-11 14:55:32 发布