Finding Oracle Version

View All Scripts Login to Run Script

Script Name Finding Oracle Version
Description By running this command, we can find the current running version of Oracle.
Area SQL General / SQL Query
Contributor Ajeet kumar
Created Saturday February 08, 2020

Statement 1

select * from PRODUCT_COMPONENT_VERSION


PRODUCT VERSION VERSION_FULL STATUS
Oracle Database 19c Enterprise Edition 19.0.0.0.0 19.5.0.0.0 Production

PRODUCT	VERSION	VERSION_FULL	STATUS
Oracle Database 19c Enterprise Edition	19.0.0.0.0	19.5.0.0.0	Production

Additional Information