Note
This view is available starting with V2.2.30.
Purpose
This view displays the names and versions of all components of the database product.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| BANNER | VARCHAR2(65536) | YES | The name and version number of the product. |
| CON_ID | NUMBER | NO | The container ID. |
Sample query
Query the version information of the database.
obclient> SELECT * FROM V$VERSION;
The query result is as follows:
+---------------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+---------------------------------------------------------------------------------------------------------------+--------+
| OceanBase 4.0.0.0 (r100000302022111120-7cef93737c5cd03331b5f29130c6e80ac950d33b) (Built Nov 11 2022 20:38:33) | 0 |
+---------------------------------------------------------------------------------------------------------------+--------+
1 row in set