网站建议:179001057@qq.com

如何查看oracle的版本信息(两种方法)

技术2022-05-11  0

以前查oracle的版本信息,只知道一种方法,就是用v$versions视图,如下: SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE    9.2.0.1.0       Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production 今天在http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#13306上又学到一种方法:query the data dictionary view PRODUCT_COMPONENT_VERSION,如下: SQL> col product format a35 SQL> col version format a15 SQL> col status format a15 SQL> select * from PRODUCT_COMPONENT_VERSION; PRODUCT                                VERSION         STATUS -----------------------------------    ---------------      --------------- NLSRTL                                 9.2.0.1.0          Production Oracle9i Enterprise Edition         9.2.0.1.0      Production PL/SQL                                  9.2.0.1.0         Production TNS for 32-bit Windows:             9.2.0.1.0          Production


最新回复(0)