方法一: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] view plaincopyprint?
- 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
http://blog.csdn.net/pan_tian/article/details/7984051
转载于:https://blog.51cto.com/302838282/1114683