Updated on 2024-05-07 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. Its value is 0.