Purpose
The V$VERSION view displays the names and versions of all components of the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| BANNER | VARCHAR2(65536) | YES | The product name and version number. |
| CON_ID | NUMBER | NO | The ID of the data container. |
Example
obclient> SELECT * FROM V$VERSION;
+---------------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+---------------------------------------------------------------------------------------------------------------+--------+
| OceanBase 4.0.0.0 (r100000302022111120-7cef93737c5cd03331b5f29130c6e80ac950d33b) (Built Nov 11 2022 20:38:33) | 0 |
+---------------------------------------------------------------------------------------------------------------+--------+
1 row in set (0.03 sec)
