如何查看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
[*] view plaincopyprint?
[*]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.iyunv.com/database/201209/155673.html
http://blog.csdn.net/pan_tian/article/details/7984051
页:
[1]