Oracle 视图 ALL_DEPENDENCIES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图 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_DEPENDENCIESdescribes all dependencies between objects in the database. This view does not display theSCHEMAIDcolumn. -
USER_DEPENDENCIESdescribes dependencies between objects in the current user’s schema. This view does not display theOWNERcolumn.
| 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:
-
“DBA_DEPENDENCIES”
-
“USER_DEPENDENCIES”
