Using Retrieve Oracle version information in Oracle

This article is written about how to locate the Oracle version data with syntax and examples.

Description

You can test the Oracle model through walking a question from the command prompt. The model records is stored in a table known as v$version. In this desk you can find the model data for Oracle, PL/SQL, etc.

Syntax

The syntax to retrieve the Oracle version facts 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 statistics from Oracle.

All Version Information

To retrieve all model data from Oracle, you ought to execute the following SQL statement:

SELECT * FROM v$version;

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

If you only wanted the Oracle version information, you execute the following SQL statement:

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

It should return something like this:

Banner
--------------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production