方法一：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版本的仍是絕大多數。
