System and Application Softwares
How to check which version of Oracle database is installed?
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 220.127.116.11.0 Production
Oracle Database 12c Enterprise Edition 18.104.22.168.0 64bit Production
PL/SQL 22.214.171.124.0 Production
TNS for 64-bit Windows: 126.96.36.199.0 Production
© 2017 Digcode.com. All rights reserved.