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 22.214.171.124.0 Production
Oracle Database 12c Enterprise Edition 126.96.36.199.0 64bit Production
PL/SQL 188.8.131.52.0 Production
TNS for 64-bit Windows: 184.108.40.206.0 Production
© 2020 Digcode.com. All rights reserved.