How to check which version of Oracle database is installed? Options

codeling 1264 - 5430
@2016-01-30 15:17:03

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.


Product     				Version      Status
NLSRTL   Production
Oracle Database 12c Enterprise Edition   64bit Production
PL/SQL   Production
TNS for 64-bit Windows:   Production
Users browsing this topic