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