1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS
  4. V$VERSION

9.129 V$VERSION

V$VERSION displays the version number of Oracle Database. The database components have the same version number as the database, so the version number is returned only once.

Column Datatype Description

BANNER

VARCHAR2(80)

Component name and version number

BANNER_FULLFoot 1

VARCHAR2(160)

The new 2 line banner format introduced in Oracle Database 18c. The banner displays the database release and version number.

BANNER_LEGACYFoot 1

VARCHAR2(80)

The legacy 1 line banner used before Oracle Database 18c. This column displays the same value as the BANNER column.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Footnote 1 This column is available starting with Oracle Database release 18c, version 18.1.