Updated on 2024-06-03 GMT+08:00

V$VERSION

V$VERSION displays the version number of the database. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.

Table 1 V$VERSION columns

Name

Type

Description

banner

character varying(80)

Component name and version number

banner_full

character varying(160)

Database version and specific version number

banner_legacy

character varying(80)

Database version

con_id

numeric

Not supported. Set it to 0.