Tuesday, August 12, 2008

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
PRODUCTVERSIONSTATUS
NLSRTL11.1.0.6.0Production
Oracle Database 11g Enterprise Edition11.1.0.6.064bit Production
PL/SQL11.1.0.6.0Production
TNS for Solaris:11.1.0.6.0Production

13 comments:

Anonymous said...

Thanks man. Verry useful.

satya said...

very usefull . good

ThomasD said...

Thanks for that! Helped us a lot.

Anonymous said...

Good stuff!

Anonymous said...

thanks!

GoForMort said...

Thanks!

Anonymous said...

Thanks

Kris said...

Thanks a lot!It worked perfectly.

Thành Nhân said...

First link in google search "select oracle version".
Save lots of time, thanks :)

Anonymous said...

Very useful, thanks.

Lyle Gunderson said...

A nice rabbit to pull out of my hat when needed!

Sujitkumar said...


Nice blog. Really helpful information about Oracle …. Please keep update some more…………

Nazeer Rahaman said...

Hello, One of the finest blog Getting the current oracle version with SQL Query is just amazing well I have done my PMP Course in Bangalore and having good command on Oracle SQL Thank you for providing the information