Overview
V$VERSION displays the names and versions of all components of the database.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| BANNER | VARCHAR2(65536) | Yes | The product name and version number. |
| CON_ID | NUMBER | NO | The container ID. |
Example
obclient> SELECT * FROM V$VERSION;
+---------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+---------------------------------------------------------------------------------------------+--------+
| OceanBase 2.2.30 (r1-f2fc546f0eb229d2c1cb9cf957b481db2b52bb4d) (Built Oct 21 2019 21:23:43) | 0 |
+---------------------------------------------------------------------------------------------+--------+
1 row in set (0.03 sec)