方法一:v$version 1.SQL select * from v$version; 2. 3.BANNER 4.-------------------------------------------------------------------------------- 5.Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production 6.PL/SQL Release
方法一:v$version
1.SQL> select * from v$version;
2.
3.BANNER
4.--------------------------------------------------------------------------------
5.Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
6.PL/SQL Release 11.1.0.7.0 - Production
7.CORE 11.1.0.7.0 Production
8.TNS for Linux: Version 11.1.0.7.0 - Production
9.NLSRTL Version 11.1.0.7.0 - Production
方法二:product_component_version
1.SQL> select * from product_component_version;
2.
3.PRODUCT VERSION STATUS
4.---------------------------------------------------------------------------------------------
5.NLSRTL 11.1.0.7.0 Production
6.Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit Production
7.PL/SQL 11.1.0.7.0 Production
8.TNS for Linux: 11.1.0.7.0 Production
9.
10.SQL>
方法三:dbms_output.put_line( dbms_db_version.version )
1.SQL> SET SERVEROUTPUT ON
2.SQL> EXEC dbms_output.put_line( dbms_db_version.version );
3.11
4.
5.PL/SQL procedure successfully completed.
6.
7.SQL>
Fenng之前做了一个关于数据库版本使用情况的调查,从图中可以看出现阶段中国地区,使用10gR2版本的仍是绝大多数。
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn