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.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The user to whom the view belongs. |
| VIEW_NAME | VARCHAR2(128) | YES | The name of the index. |
| TEXT_LENGTH | NUMBER | NO | The length of the view text. |
| TEXT | CLOB | NO | View definition |
| TEXT_VC | VARCHAR2(4000) | NO | The field is not supported at present. The field is currently set to NULL as default. |
| TYPE_TEXT_LENGTH | NUMBER | NO | Not supported and set to NULL by default |
| TYPE_TEXT | VARCHAR2(4000) | NO | This field is not supported at the moment and defaults to NULL. |
| OID_TEXT_LENGTH | NUMBER | NO | This field is not supported and is currently NULL by default. |
| OID_TEXT | VARCHAR2(4000) | NO | Currently, this field is not supported, and its default value is NULL. |
| VIEW_TYPE_OWNER | VARCHAR2(128) | NO | This field is not supported. The default value is NULL. |
| VIEW_TYPE | VARCHAR2(30) | NO | Currently, this field is not supported and defaults to NULL. |
| SUPERVIEW_NAME | VARCHAR2(30) | NO | This field is not supported and is NULL by default. |
| EDITIONING_VIEW | VARCHAR2(1) | NO | The field is not supported at present and defaults to NULL. |
| READ_ONLY | VARCHAR2(1) | NO | The field is currently not supported, and its default value is NULL. |
| CONTAINER_DATA | VARCHAR2(1) | NO | This field is not currently supported. The default value of this field is NULL. |
| BEQUEATH | VARCHAR2(12) | NO | This field is not supported. The field is set to NULL by default. |
| ORIGIN_CON_ID | NUMBER | NO | This field is not supported and currently default to NULL |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | This field is not supported now, and is currently set to NULL by default. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | The field is not supported and will be set to NULL by default. |
| CONTAINER_MAP | VARCHAR2(2) | NO | The value of this parameter is currently NULL. This parameter is not supported yet. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | Not supported. The value of this field is NULL. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | The value of this field is currently always NULL. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | This field is not supported and is NULL by default. |
| ADMIT_NULL | VARCHAR2(3) | NO | This field is temporarily not supported. The default value is NULL. |
| PDB_LOCAL_ONLY | VARCHAR2(3) | NO | This field is not supported and is currently NULL by default. |
Sample query
View the information about the VIEW2 view in all views accessible by the current user.
obclient [SYS]> SELECT OWNER, VIEW_NAME, TEXT_LENGTH, TEXT FROM SYS.DBA_VIEWS WHERE VIEW_NAME='VIEW2';
The query result is as follows:
+-------+-----------+-------------+--------------------------------------------+
| OWNER | VIEW_NAME | TEXT_LENGTH | TEXT |
+-------+-----------+-------------+--------------------------------------------+
| SYS | VIEW2 | 42 | SELECT "A","B" FROM tbl2 WHERE tbl2.b > 1 |
+-------+-----------+-------------+--------------------------------------------+
1 row in set
Related views or documents
View all views under the current tenant: DBA_VIEWS
View views of the current user: USER_VIEWS
For more information about the view creation syntax, see CREATE VIEW.