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

12 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…………