Home  >  Article  >  Database  >  如何查看Oracle数据库版本

如何查看Oracle数据库版本

WBOY
WBOYOriginal
2016-06-07 17:59:031642browse

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