Purpose
V$VERSION displays the names and versions of all components of the database.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| BANNER | VARCHAR2(65536) | YES | The name and version number of the product. |
| CON_ID | NUMBER | NO | The ID of the container. |
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)