To identify the release of Oracle Database that is currently installed and to see the
release levels of other database components you are using, query the data dictionary
view PRODUCT_COMPONENT_VERSION. A sample query follows. (You can also query
the V$VERSION view to see component-level information.) Other product release
levels may increment independent of the database server.
COL PRODUCT FORMAT A35
COL VERSION FORMAT A15
COL STATUS FORMAT A15
SELECT * FROM PRODUCT_COMPONENT_VERSION;
It is important to convey to Oracle the results of this query when you report problems
with the software.
检查当前Oracle版本号
可通过字典表 PRODUCT_COMPONENT_VERSION 或者 V$VERSION
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-994269/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
