查看Oracle版本

How to check oracle version when a DB OSSD  upgraded to 11R2:

 

SQL> show parameter db_name

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_name                              string      OSSD

SQL> select * from v$version;

 

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE    11.2.0.3.0      Production

TNS for HPUX: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 – Production