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.

Description

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.

Syntax

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.

Example

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 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production

Oracle Version Only

digitalcollections superherohype popcouncil astro-wisc curseforge kaskus telstra wikimapia nutritiondata rtve tools talgov.com minecraft researchgate infojardin camfrog engawa auone domaindirectory hkex sie inginformatica bonanza opendns
Source: www.techonthenet.com
Related Posts