How to Find Oracle Database Component Version Installed

How to Find Oracle Database Component Version Installed 

Checking Your Current oraceRelease Number



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. (You can also query the V$VERSION view to see component-level information.)



COL PRODUCT FORMAT A40

COL VERSION FORMAT A15

COL STATUS FORMAT A15

SELECT * FROM PRODUCT_COMPONENT_VERSION;



PRODUCT VERSION STATUS

---------------------------------------- ----------- -----------

NLSRTL 12.1.0.0.1 Production

Oracle Database 12c Enterprise Edition 12.1.0.0.1 Production

PL/SQL 12.1.0.0.1 Production