GeekInterview.com
Series: Subject: Topic:
Question: 94 of 133

To view installed Oracle version information


Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following: 
 
select * from v$version;
Asked by: Interview Candidate | Asked on: May 25th, 2005
Showing Answers 1 - 4 of 4 Answers
Scott

Answered On : May 25th, 2005

From the SQL> prompt, type the following:  select * from v$version;

  
Login to rate this answer.
Shasi

Answered On : Jan 7th, 2006

There is one more view called product_component_version which can queried to get all the version details

  
Login to rate this answer.
deepakonroll

Answered On : Dec 26th, 2007

View all answers by deepakonroll

Just type define on your sql prompt ..you will get required info..

  
Login to rate this answer.
emraan

Answered On : Dec 29th, 2009

View all answers by emraan

      select * from v$version

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.