Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links. This view does not display the SCHEMAID column.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the object
NAME VARCHAR2(30) NOT NULL Name of the object
TYPE VARCHAR2(17)   Type of the object
REFERENCED_OWNER VARCHAR2(30)   Owner of the referenced object (remote owner if remote object)
REFERENCED_NAME VARCHAR2(64)   Name of the referenced object
REFERENCED_TYPE VARCHAR2(17)   Type of the referenced object
REFERENCED_LINK_NAME VARCHAR2(128)   Name of the link to the parent object (if remote)
SCHEMAID NUMBER   ID of the current schema
DEPENDENCY_TYPE VARCHAR2(4)   Indicates whether the dependency is a REF dependency (REF) or not (HARD)