How to check Oracle Database version

Michal Wrobel - Dataedo Team Michal Wrobel 2018-07-06

Table of Contents:


    Queries below return server version, edition and system information.

    Using V$VERSION

    Query

    select * from V$VERSION
    

    Columns

    • banner - string containing server information

    Rows

    Query returns many rows, each containing information about core Oracle component.

    Sample results

    Oracle 11g XE on Linux server:

    Sample results

    Oracle 9i on AIX server:

    Sample results

    Using V$INSTANCE

    If you have dba privilege you can access database version information in V$INSTANCE view

    Query

    select version from V$INSTANCE
    

    Columns

    • version - database version information

    Rows

    Query returns just one row

    Sample results

    Oracle 11g XE:

    Sample results

    Oracle 9i:

    Sample results

    Releases

    Oracle is using release naming convention. You can translate version number to release name for contemporary releases with this table:

    Version no Release name
    9.0.x.x Oracle9i Database
    9.2.x.x Oracle9i Database Release 2
    10.1.x.x Oracle Database 10g Release 1
    10.2.x.x Oracle Database 10g Release 2
    11.1.x.x Oracle Database 11g Release 1
    11.2.x.x Oracle Database 11g Release 2
    12.1.x.x Oracle Database 12c Release 1
    12.2.x.x Oracle Database 12c Release 2
    18.1.x.x Oracle Database 18c
    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept