Purpose
The ALL_DEPENDENCIES view displays the dependencies among all the objects accessible to the current user. At present, only dependencies among Procedural Language (PL) objects are displayed.
Applicability
This content is only applicable to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides the MySQL mode.
Related views
DBA_DEPENDENCIESUSER_DEPENDENCIES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The name of the owner of the dependent object. |
| NAME | VARCHAR2(128) | NO | The name of the dependent object. |
| TYPE | VARCHAR2(23) | NO | The type of the dependent object. |
| REFERENCED_OWNER | VARCHAR2(128) | NO | The name of the owner of the referenced object. |
| REFERENCED_NAME | VARCHAR2(128) | NO | The name of the referenced object. |
| REFERENCED_TYPE | VARCHAR2(18) | NO | The type of the referenced object. |
| REFERENCED_LINK_NAME | VARCHAR2(128) | NO | The DBLink name of the referenced object. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | Indicates whether the dependency is a strong dependency. |