查詢 Oracle 資料庫版本 Find out Oracle database version

查看Oracle資料庫安裝版本的方式如下。

連線資料庫後輸入SELECT * FROM v$version;指令即可查看Oracle版本

+-------------------------------------------------------------------------------+--------+
|                                    BANNER                                     | CON_ID |
+-------------------------------------------------------------------------------+--------+
| Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production  |      0 |
| PL/SQL Release 12.2.0.1.0 - Production                                        |      0 |
| CORE 12.2.0.1.0 Production                                                    |      0 |
| TNS for 64-bit Windows: Version 12.2.0.1.0 - Production                       |      0 |
| NLSRTL Version 12.2.0.1.0 - Production                                        |      0 |
+-------------------------------------------------------------------------------+--------+