Check Oracle version

Login as Oracle user

$ sqlplus / as sysdba

SQL> select * from v$version;

The command output is similar to the following information:



Oracle Database 11g Enterprise Edition Release – 64bit Production

PL/SQL Release – Production

CORE      Production

TNS for Linux: Version – Production

NLSRTL Version – Production

In the preceding information, 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: 664