Here you go

Showing posts with label How to find dependent objects in oracle?. Show all posts
Showing posts with label How to find dependent objects in oracle?. Show all posts

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))