Getting the current Oracle version (via a SQL Select query)

Queries :

select *
from v$version;

select *
from product_component_version;

Results :

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production






PRODUCT
VERSION
STATUS


NLSRTL
11.1.0.6.0
Production


Oracle Database 11g Enterprise Edition
11.1.0.6.0
64bit Production


PL/SQL
11.1.0.6.0
Production


TNS for Solaris:
11.1.0.6.0
Production