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-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| BANNER | VARCHAR2(65536) | YES | The name and version of the database product. |
| CON_ID | NUMBER | NO | The container ID. |
Sample query
Query the version of the database.
obclient> SELECT * FROM V$VERSION;
The query result is as follows:
+---------------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+---------------------------------------------------------------------------------------------------------------+--------+
| OceanBase 4.4.0.0 (r100000562025070723-014a767e54eac8efc0e4a5c8bbc34126e41892dd) (Built Jul 7 2025 23:15:18) | 0 |
+---------------------------------------------------------------------------------------------------------------+--------+
1 row in set