SELECT a.object_type,
a.object_name,
b.owner,
b.object_type,
b.object_name,
b.object_id,
b.status,
b.last_ddl_time
FROM sys.DBA_OBJECTS a,
sys.DBA_OBJECTS b,
( SELECT object_id, referenced_object_id
FROM public_dependency
START WITH object_id =
(SELECT object_id
FROM sys.DBA_OBJECTS
WHERE wner = 'DFMS'
AND object_name = 'SP_WIP_TRANSFER'
AND object_type = 'PROCEDURE')
CONNECT BY PRIOR referenced_object_id = object_id) c
WHERE a.object_id = c.object_id
AND b.object_id = c.referenced_object_id
AND a.owner NOT IN ('SYS', 'SYSTEM')
AND b.owner NOT IN ('SYS', 'SYSTEM')
AND a.object_name <> 'DUAL'
AND b.object_name <> 'DUAL'
ORDER BY 8 DESC;
a.object_name,
b.owner,
b.object_type,
b.object_name,
b.object_id,
b.status,
b.last_ddl_time
FROM sys.DBA_OBJECTS a,
sys.DBA_OBJECTS b,
( SELECT object_id, referenced_object_id
FROM public_dependency
START WITH object_id =
(SELECT object_id
FROM sys.DBA_OBJECTS
WHERE wner = 'DFMS'
AND object_name = 'SP_WIP_TRANSFER'
AND object_type = 'PROCEDURE')
CONNECT BY PRIOR referenced_object_id = object_id) c
WHERE a.object_id = c.object_id
AND b.object_id = c.referenced_object_id
AND a.owner NOT IN ('SYS', 'SYSTEM')
AND b.owner NOT IN ('SYS', 'SYSTEM')
AND a.object_name <> 'DUAL'
AND b.object_name <> 'DUAL'
ORDER BY 8 DESC;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-627387/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
