How to get Oracle database version?

Question

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

Answer 1

Try running this query in SQLPLUS -

select * from v$version

Answer 2

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