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 Send mail to the author(s)
Archive
<September 2010>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Blogs I read
Disclaimer

Disclaimer
Postings are provided as is with no warranties, and confer no rights. Opinions expressed here are my own delusions; my employers at best shake their heads and sigh, at worst repudiate the content with extreme prejudice, whenever it manages to appear on their radar.

© Copyright 2010
Rujith Anand

Statistics
Advertisement
All Content © 2010, Rujith Anand