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

21 comments:

Anonymous said...

Thanks man. Verry useful.

bhaskar 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.

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

nancy said...

Nice blog with excellent information. Thank you, keep sharing.

gautham said...

Great post to learn on oracle. one can also learn on azure through microsoft azure certification

svrtechnologies said...

This post is really nice and informative. The explanation given is really comprehensive azure tutorial and informative.

sharan said...

I have joined the oracle Trained in Training in Bangalore. Oracle Trainer will be teaching in practically Manner..
Microsoft Windows Azure Training | Online Course | Certification in chennai | Microsoft Windows Azure Training | Online Course | Certification in bangalore | Microsoft Windows Azure Training | Online Course | Certification in hyderabad | Microsoft Windows Azure Training | Online Course | Certification in pune

shankarjaya said...

Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.
Salesforce Training in Chennai | Certification | Online Course | Salesforce Training in Bangalore | Certification | Online Course | Salesforce Training in Hyderabad | Certification | Online Course | Salesforce Training in Pune | Certification | Online Course | Salesforce Online Training | Salesforce Training

Jagna Co Kalani said...

Great Article
Cyber Security Projects

projects for cse

Networking Projects

JavaScript Training in Chennai
JavaScript Training in Chennai

Python said...

Thank you for sharing.
Data Science Online Training
Python Online Training
Salesforce Online Training

Unknown said...

www.escortsmate.com
escortsmate.com
https://www.escortsmate.com

Hamad said...

Data Science Course in Hyderabad designed for students and professionals who want to build their career as a Data Analyst or Data Scientist. Data Science is one of the trending course in the present day. There a massive demand for Data Analyst or Data Scientist. Every company may be a start-up or Mnc’s looking for a Data Analyzer.