Purpose
The USER_VIEWS view displays the views owned by the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
ALL_VIEWS
DBA_VIEWS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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 | At present, this column is not supported and its value is NULL by default. |
| READ_ONLY | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |