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

18 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!

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

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.

Ramesh Sampangi said...

Become a data science expert by joining AI Patasala’s Data Science Training in Hyderabad, where you can learn more advanced data science topics with real-time experience. AI Patasala offers both online and offline classroom training sessions for data science aspirants. After completion of the course, you will receive industry-recognized certification, which will help you get a data science job in top MNCs.
Data Science Course Training Institute in Hyderabad with Placements

Beel Khan said...

This is demanding at the present as you have to buy all those application which are luxurious to unlock a folder. This happen since user has not the necessary application. File View Pro Crack

VAANIL NILA said...
This comment has been removed by the author.