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. For details about the columns, see Table 1.

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. It is always 0.