CentOS下查看Oracle数据库版本

分类:CentOS教程 阅读:21468 次

方法一:v$version数据库培训

  SQL> select * from v$version;

  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

  方法二:product_component_version

  SQL> select * from product_component_version;

  PRODUCT VERSION STATUS

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

  NLSRTL 11.1.0.7.0 Production

  Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit Production

  PL/SQL 11.1.0.7.0 Production

  TNS for Linux: 11.1.0.7.0 Production

  SQL>

  方法三:dbms_output.put_line( dbms_db_version.version )

  SQL> SET SERVEROUTPUT ON

  SQL> EXEC dbms_output.put_line( dbms_db_version.version );

  11 PL/SQL procedure successfully completed.

  SQL>