linux怎么查看oracle数据库版本,CentOS下查看Oracle数据库版本

CentOS下查看Oracle数据库版本

方法一：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>

http://www.dengb.com/Linuxjc/846720.htmlwww.dengb.comtruehttp://www.dengb.com/Linuxjc/846720.htmlTechArticleCentOS下查看Oracle数据库版本 方法一：v$version数据库培训 SQL select * from v$version; BANNER ----------------------------------------------------------------------...