Oracle database version query

Oracle / PLSQL: Retrieve Oracle version information
December 21, 2021 – 11:25 am
Repository | Pardy DBA

This Oracle tutorial explains how to find the Oracle version information with syntax and examples.


You can check the Oracle version by running a query from the command prompt. The version information is stored in a table called v$version. In this table you can find the version information for Oracle, PL/SQL, etc.


The syntax to retrieve the Oracle version information is:

SELECT * FROM v$version;

OR ...

SELECT * FROM v$version WHERE banner LIKE 'Oracle%';

Parameters or Arguments

There are no parameters or arguments.


Let's look at some of examples of how to retrieve version information from Oracle.

All Version Information

To retrieve all version information from Oracle, you could execute the following SQL statement:

This query would output something like this:

Banner - Oracle Database 11g Express Edition Release - 64bit Production PL/SQL Release - Production CORE Production TNS for Linux: Version - Production NLSRTL Version - Production

Oracle Version Only

digitalcollections superherohype popcouncil astro-wisc curseforge kaskus telstra wikimapia nutritiondata rtve tools minecraft researchgate infojardin camfrog engawa auone domaindirectory hkex sie inginformatica bonanza opendns
Related Posts