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

codeling Posts: 1089 Points: 4569
Posted: Saturday, January 30, 2016 3:17:03 PM

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.

SELECT * FROM PRODUCT_COMPONENT_VERSION;

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