以前查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
一种方法: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
查oracle的版本信息
最新推荐文章于 2022-11-22 09:40:45 发布