Search This Blog

Monday, February 18, 2013

API to get DEPENDENT OBEJCTS


API to get DEPENDENT OBEJCTS:


DBMS_UTILITY.GET_DEPENDENCY
   type      IN     VARCHAR2,
   schema    IN     VARCHAR2,
   name      IN     VARCHAR2);

SELECT * FROM ALL_DEPENDENCIES

Using above method, we can find out the Dependent Objects.

No comments:

Post a Comment