How to check the version of an Oracle Database with PL/SQL

Oct 3, 2012 | Databases, Oracle, oracle pl/sql

Login to the database and execute the following:

[sql]select * from v$version;
–OR:
select * from product_component_version;[/sql]

Result:

[text]Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE    11.1.0.7.0    Production
TNS for 64-bit Windows: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production[/text]