Feature
USER_VIEWS lists 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
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| VIEW_NAME | VARCHAR2(128) | NO | The name of the view. |
| 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 field is not supported and is NULL by default. |
| OID_TEXT | VARCHAR2(4000) | NO | The WITH OID clause of the typed view. At present, this field 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 field is not supported and is NULL by default. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | The name of the superview. At present, this field is not supported and is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | Reserved for future use. At present, this field is not supported and is NULL by default. |
| READ_ONLY | VARCHAR2(1) | NO | Indicates whether the view is read-only. At present, this field is not supported and is NULL by default. |