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
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.