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

Answered On : May 25th, 2005

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

Login to rate this answer.

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.

Answered On : Dec 26th, 2007

View all answers by deepakonroll

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

Login to rate this answer.

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



twitter fb Linkedin GPlus RSS


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.