Note
This view is available starting with V2.2.30.
Purpose
This view displays the views owned by the current user.
Applicability
This view is available starting with OceanBase Database Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| VIEW_NAME | VARCHAR2(128) | YES | The name of the view. |
| TEXT_LENGTH | NUMBER | NO | The length of the view definition. |
| TEXT | CLOB | NO | The text of the view. |
| TEXT_VC | VARCHAR2(4000) | NO | This column is not supported. The default value is NULL. |
| TYPE_TEXT_LENGTH | NUMBER | NO | This column is not supported. The default value is NULL. |
| TYPE_TEXT | VARCHAR2(4000) | NO | This column is not supported. The default value is NULL. |
| OID_TEXT_LENGTH | NUMBER | NO | This column is not supported. The default value is NULL. |
| OID_TEXT | VARCHAR2(4000) | NO | This column is not supported. The default value is NULL. |
| VIEW_TYPE_OWNER | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| VIEW_TYPE | VARCHAR2(30) | NO | This column is not supported. The default value is NULL. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | This column is not supported. The default value is NULL. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | This column is not supported. The default value is NULL. |
| READ_ONLY | VARCHAR2(1) | NO | This column is not supported. The default value is NULL. |
| CONTAINER_DATA | VARCHAR2(1) | NO | This column is not supported. The default value is NULL. |
| BEQUEATH | VARCHAR2(12) | NO | This column is not supported. The default value is NULL. |
| ORIGIN_CON_ID | NUMBER | NO | This column is not supported. The default value is NULL. |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | This column is not supported. The default value is NULL. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| CONTAINER_MAP | VARCHAR2(2) | NO | This column is not supported. The default value is NULL. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| ADMIT_NULL | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| PDB_LOCAL_ONLY | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
Sample query
Query the information about the view VIEW1 owned by the current user.
obclient [SYS]> SELECT VIEW_NAME, TEXT_LENGTH, TEXT FROM SYS.USER_VIEWS WHERE VIEW_NAME='VIEW1';
The query result is as follows:
+-----------+-------------+-----------------------------+
| VIEW_NAME | TEXT_LENGTH | TEXT |
+-----------+-------------+-----------------------------+
| VIEW1 | 27 | SELECT col1, col2 FROM tbl1 |
+-----------+-------------+-----------------------------+
1 row in set
References
Query all views accessible to the current user: ALL_VIEWS
Query all views in the current tenant: DBA_VIEWS
For more information about the syntax of the CREATE VIEW statement, see CREATE VIEW.