方法一2113:v$versionsql>select*fromv$version;banner--------------------------------------------------------------------------------oracledatabase11genterpriseeditionrelease11.1.0.7.0-64bitproductionpl/sqlrelease11.1.0.7.0-productioncore11.1.0.7.0productiontnsforlinux:version11.1.0.7.0-productionnlsrtlversion11.1.0.7.0-production方法二:product_component_versionsql>select*fromproduct_component_version;productversionstatus---------------------------------------------------------------------------------------------nlsrtl11.1.0.7.0productionoracledatabase11genterpriseedition11.1.0.7.064bitproductionpl/sql11.1.0.7.0productiontnsforlinux:11.1.0.7.0productionsql>方法三:dbms_output.put_line(dbms_db_version.version)sql>setserveroutputonsql>execdbms_output.put_line(dbms_db_version.version);11pl/sqlproceduresuccessfullycompleted.sql>oracledatabasehistorysinceversion5,oracle\'srdbmsreleasenumberinghasusedthefollowingcodes:oraclev5oraclev6oracle7:7.0.16–52617.3.4oracle8database:8.0.3–8.0.6oracle8idatabaserelease1:8.1.5.0–8.1.5.1oracle8idatabaserelease2:8.1.6.0–8.1.6.3oracle8idatabaserelease3:8.1.7.0–8.1.7.4oracle9idatabaserelease1:9.0.1.0–9.0.1.5(patchsetasofdecember2003)oracle9idatabaserelease2:9.2.0.1–9.2.0.8(patchsetasofapril2007)oracledatabase10grelease1:10.1.0.2–10.1.0.5(patchsetasoffebruary2006)oracledatabase10grelease2:10.2.0.1–10.2.0.5(patchsetasofapril2010)oracledatabase11grelease1:11.1.0.6–11.1.0.7(patchsetasofseptember2008)oracledatabase11grelease2:11.2.0.1–11.2.0.3(patchsetasofseptember2011)theversion-numberingsyntaxwithineachreleasefollowsthepattern:major.maintenance.application-server.component-specific.platform-specific.forexample,"10.2.0.1for64-bitsolaris"means:10thmajorversionoforacle,maintenancelevel2,oracleapplicationserver(oracleas)0,level1forsolaris64-bit.另外4102,fenng之前做了一个关于数据库版本使1653用情况的调查,从图中可以看出现阶段中国地区,使用10gr2版本的仍是绝大多数。
阅读全文 >