The techie in me RSS 2.0
 Sunday, September 13, 2009

If you are connected and logged in sql plus and want to know the version of Oracle you connected to via sqlplus command, following are the quickest methods

1. Type ‘define’ in SQL prompt(ex :SQL> define)
2. use query – select * from v$version;
3. use the view called - product_component_version.
4. check the registry (though this is not through sql plus :-) )

-Rujith

Sunday, September 13, 2009 7:57:00 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] -
Non MS
About me
Name : Rujith Anand
Occupation : Eating, drinking, sleeping and Yes ofcourse coding.
Location : Reading, UK
Archive
<March 2010>
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Blogs I read
Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2010
Rujith Anand

Statistics
Follow me on Twitter
All Content © 2010, Rujith Anand