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

總結

以上是生活随笔為你收集整理的如何查看oracle版本信息,如何查看oracle版本信息的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。