Here you go

Wednesday, May 28, 2014

Oracle Dependent Objects / Query to find Dependent Views , Functions, Procedures and Fast Formulas



How to find dependent objects in Oracle?


SELECT A.OWNER||'.'||A.NAME DEPENDENT_OBJECTS
FROM
    (
      SELECT
            *
      FROM
            DBA_DEPENDENCIES
    ) A
START WITH REFERENCED_NAME = :OBJECT_NAME
CONNECT BY  NOCYCLE ((REFERENCED_NAME = PRIOR NAME) AND (REFERENCED_OWNER = PRIOR OWNER))

No comments:

Post a Comment

Thanks for making a comment.