2.115 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
-
DBA_DEPENDENCIES
describes all dependencies between objects in the database. This view does not display theSCHEMAID
column. -
USER_DEPENDENCIES
describes dependencies between objects in the current user's schema. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the object |
|
|
|
Name of the object |
|
|
|
Type of the object |
|
|
|
Owner of the referenced object (remote owner if remote object) |
|
|
|
Name of the referenced object |
|
|
|
Type of the referenced object |
|
|
|
Name of the link to the parent object (if remote) |
|
|
|
Indicates whether the dependency is a |
See Also: