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
Leave a Review