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 |
| PRODUCT | VERSION | STATUS |
| NLSRTL | 11.1.0.6.0 | Production |
| Oracle Database 11g Enterprise Edition | 11.1.0.6.0 | 64bit Production |
| PL/SQL | 11.1.0.6.0 | Production |
| TNS for Solaris: | 11.1.0.6.0 | Production |
Posts
18 comments:
Thanks man. Verry useful.
very usefull . good
Thanks for that! Helped us a lot.
Good stuff!
thanks!
Thanks a lot!It worked perfectly.
First link in google search "select oracle version".
Save lots of time, thanks :)
Very useful, thanks.
A nice rabbit to pull out of my hat when needed!
Nice blog. Really helpful information about Oracle …. Please keep update some more…………
Nice blog with excellent information. Thank you, keep sharing.
Great post to learn on oracle. one can also learn on azure through microsoft azure certification
This post is really nice and informative. The explanation given is really comprehensive azure tutorial and informative.
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
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.
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
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
Post a Comment