Articles‎ > ‎Technical Articles‎ > ‎

Get Oracle Version ( SQL )

posted Jul 9, 2010, 10:58 AM by Thiyagaraaj M   [ updated Jul 9, 2010, 11:05 AM ]

Select Database Version

select * from v$version;
BANNER
-----------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production


Select Full Product Details

select * from product_component_version;

PRODUCT
-----------------------------------------------------------
VERSION
-----------------------------------------------------------
STATUS
-----------------------------------------------------------
NLSRTL
10.2.0.2.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.2.0
Prod

PRODUCT
-----------------------------------------------------------
VERSION
-----------------------------------------------------------
STATUS
-----------------------------------------------------------

PL/SQL
10.2.0.2.0
Production

TNS for Solaris:
10.2.0.2.0

PRODUCT
-----------------------------------------------------------
VERSION
-----------------------------------------------------------
STATUS
-----------------------------------------------------------
Production


Select Version With Banner


select * from v$version where banner like 'Oracle%';
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod

Select Version With Banner


select * from v$version where banner like 'PL/SQL%';
BANNER
----------------------------------------------------------------
PL/SQL Release 10.2.0.2.0 - Production

Comments