31 lines
1.3 KiB
MySQL
31 lines
1.3 KiB
MySQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/monitoring/code_dep_distinct.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays a tree of dependencies of specified object.
|
|
-- Call Syntax : @code_dep_distinct (schema-name) (object-name) (object_type or all)
|
|
-- Last Modified: 15/07/2000
|
|
-- -----------------------------------------------------------------------------------
|
|
SET VERIFY OFF
|
|
SET LINESIZE 255
|
|
SET PAGESIZE 1000
|
|
|
|
COLUMN referenced_object FORMAT A50
|
|
COLUMN referenced_type FORMAT A20
|
|
COLUMN referenced_link_name FORMAT A20
|
|
|
|
SELECT DISTINCT a.referenced_owner || '.' || a.referenced_name AS referenced_object,
|
|
a.referenced_type,
|
|
a.referenced_link_name
|
|
FROM all_dependencies a
|
|
WHERE a.owner NOT IN ('SYS','SYSTEM','PUBLIC')
|
|
AND a.referenced_owner NOT IN ('SYS','SYSTEM','PUBLIC')
|
|
AND a.referenced_type != 'NON-EXISTENT'
|
|
AND a.referenced_type = DECODE(UPPER('&3'), 'ALL', a.referenced_type, UPPER('&3'))
|
|
START WITH a.owner = UPPER('&1')
|
|
AND a.name = UPPER('&2')
|
|
CONNECT BY a.owner = PRIOR a.referenced_owner
|
|
AND a.name = PRIOR a.referenced_name
|
|
AND a.type = PRIOR a.referenced_type;
|
|
|
|
SET VERIFY ON
|
|
SET PAGESIZE 22 |