Question: How do I check the Oracle version from the command prompt?
Answer: Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc.
To retrieve the version information for Oracle, you execute the following SQL statement:
select * from v$version where banner like 'Oracle%';
It should return something like this:
Banner -------------------------------------------------------------------------------------- Oracle11 Enterprise Edition Release 11.2.0.1.0 - 64bit Production
