Purpose
The ALL_VIEWS view displays all views accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_VIEWS
USER_VIEWS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the view. |
| VIEW_NAME | VARCHAR2(128) | NO | The name of the index. |
| TEXT_LENGTH | NUMBER | NO | The length of the view text. |
| TEXT | VARCHAR2(4000) | NO | The view text. |
| OID_TEXT_LENGTH | NUMBER | NO | The length of the WITH OID clause of the typed view. At present, this column is not supported and is NULL by default. |
| OID_TEXT | VARCHAR2(4000) | NO | The WITH OID clause of the typed view. At present, this column is not supported and is NULL by default. |
| VIEW_TYPE | VARCHAR2(30) | NO | The type of the view if the view is a typed view. At present, this column is not supported and is NULL by default. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | The name of the superview. At present, this column is not supported and is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | Reserved for future use. |
| READ_ONLY | VARCHAR2(1) | NO | Indicates whether the view is read-only. At present, this column is not supported and is NULL by default. |