Purpose
The USER_VIEWS view displays the views owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_VIEWS
DBA_VIEWS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| VIEW_NAME | VARCHAR2(128) | NO | The name of the index. |
| TEXT_LENGTH | NUMBER | NO | The defined length of the view. |
| 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 super view. At present, this column is not supported and is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | Reserved for future use. At present, this column is not supported and is NULL by default. |
| READ_ONLY | VARCHAR2(1) | NO | Indicates whether the view is read-only. At present, this column is not supported and is NULL by default. |