CentOS下查看Oracle数据库版本
时间:2014-06-21 02:43 来源:www.it.net.cn 作者:IT网
方法一：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>
(责任编辑：IT)
| 方法一：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> (责任编辑：IT) |