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

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

Unknown said...

ONLEI Technologies
Industrial Training In Noida
Winter Training In Noida
IT Training

Unknown said...

APOTAC

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

ram said...

Infycle Technology, No.1 Software Training Institute in Chennai, afford best Data Science training in Chennai and also provide technical courses like Oracle, Java, Big data, AWS, Python, DevOps, Digital Marketing, Selenium Testing, etc., and we also provide the best training from the best technical trainers and after completion of training students will be able to crack the jobs on top MNC’s. for more information call 7504633633.

Unknown said...

ONLEI Technologies
Internship
Best Online Python Certification Course
Best Online Data Science Certification Course
Best Online Machine Learning Certification Course
Python Training
Machine Learning
Data Science
Digital Marketing

Unknown said...

Business Analyst Certification Training
Django Course Online

Unknown said...

Python Training In Mohali
Data ScienceTraining In Mohali

cdsvdfvdfvdf said...

tiktok jeton hilesi
tiktok jeton hilesi
referans kimliği nedir
gate güvenilir mi
tiktok jeton hilesi
paribu
btcturk
bitcoin nasıl alınır
yurtdışı kargo

hasaokı said...

İnstagram takipçi satın al! İnstagram takipçi sitesi ile takipçi satın al sende sosyal medyada fenomen olmaya bir adım at. Sende hemen instagram takipçi satın almak istiyorsan tıkla:

1- takipçi satın al

2- takipçi satın al

3- takipçi satın al

Peter Johnson said...

I am inspired with your post writing style & how continuously you describe this topic. micro nutrient for plant