Check Oracle version

Login as Oracle user

$ sqlplus / as sysdba

SQL> select * from v$version;

The command output is similar to the following information:

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production

PL/SQL Release 11.1.0.7.0 – Production

CORE    11.1.0.7.0      Production

TNS for Linux: Version 11.1.0.7.0 – Production

NLSRTL Version 11.1.0.7.0 – Production

In the preceding information, 11.1.0.7.0 is the version of the Oracle database.


 

Jan D.
Jan D.

"The only real security that a man will have in this world is a reserve of knowledge, experience, and ability."

Articles: 674