Search code examples
sqloracle-databaseversion

How to get Oracle database version?

How to get Oracle database version from sqlplus, Oracle SQL developer, SQL Navigator or other IDE?

Solution

  • Execute this statement from SQL*Plus, SQLcl, Oracle SQL Developer, SQL Navigator or other IDE:

    select * from product_component_version

    And you'll get:

    PRODUCT                                VERSION    VERSION_FULL STATUS
-------------------------------------- ---------- ------------ ----------
Oracle Database 18c Enterprise Edition 18.0.0.0.0 18.3.0.0.0   Production