如何查看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.2cto.com/database/201209/155673.html