SQL Plus - To view installed Oracle version information

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 40 of 132

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;

Total Answers and Comments: 3

Last Update: December 26, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

May 25, 2005 18:41:26

Scott

RE: To view installed Oracle version information

From the SQL> prompt type the following:

select * from v$version;

Is this answer useful? Yes | No

January 07, 2006 21:13:37

Shasi

RE: To view installed Oracle version information

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

Is this answer useful? Yes | No

December 26, 2007 08:33:31

deepakonroll

Member Since: December 2007 Contribution: 2

RE: To view installed Oracle version information

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank