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