查看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 |
+-------------------------------------------------------------------------------+--------+
沒有留言:
張貼留言