Purpose
The ALL_VIEWS view displays all views accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
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 | At present, this column is not supported and its value is NULL by default. |
| OID_TEXT | VARCHAR2(4000) | NO | At present, this column is not supported and its value is NULL by default. |
| VIEW_TYPE | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | Reserved for future use. |
| READ_ONLY | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |