Checking Your Current Release Number (23)

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

[@more@]
请使用浏览器的分享功能分享到微信等