Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_DEPENDENCIES

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 object
REFERENCED_OWNER VARCHAR2(30)   Owner of the parent object
REFERENCED_NAME VARCHAR2(64)   Type of parent object
REFERENCED_TYPE VARCHAR2(17)   Type of 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)   Whether the dependency is a REF dependency (REF) or not (HARD)