Rujith Anand's space - Non MS http://www.rujith.net/RujithBlogTech/ The techie in me en-us Rujith Anand Sun, 13 Sep 2009 19:57:00 GMT newtelligence dasBlog 2.0.7226.0 rujith@rujith.net rujith@rujith.net http://www.rujith.net/RujithBlogTech/Trackback.aspx?guid=8b52a21c-f1a2-49c7-897b-532be0d63843 http://www.rujith.net/RujithBlogTech/pingback.aspx http://www.rujith.net/RujithBlogTech/PermaLink,guid,8b52a21c-f1a2-49c7-897b-532be0d63843.aspx Rujith Anand http://www.rujith.net/RujithBlogTech/CommentView,guid,8b52a21c-f1a2-49c7-897b-532be0d63843.aspx http://www.rujith.net/RujithBlogTech/SyndicationService.asmx/GetEntryCommentsRss?guid=8b52a21c-f1a2-49c7-897b-532be0d63843

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

How to get the Oracle version through sqlplus http://www.rujith.net/RujithBlogTech/PermaLink,guid,8b52a21c-f1a2-49c7-897b-532be0d63843.aspx http://www.rujith.net/RujithBlogTech/2009/09/13/HowToGetTheOracleVersionThroughSqlplus.aspx Sun, 13 Sep 2009 19:57:00 GMT <p> 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 </p> <p> 1. Type ‘define’ in SQL prompt(ex :SQL&gt; define)<br> 2. use query – select * from v$version;<br> 3. use the view called - product_component_version.<br> 4. check the registry (though this is not through sql plus :-) ) </p> <p> -Rujith </p> http://www.rujith.net/RujithBlogTech/CommentView,guid,8b52a21c-f1a2-49c7-897b-532be0d63843.aspx Non MS