Find Oracle version and edition

How to know Oracle edition and version number in use for this instance.

The easiest way to know Oracle edition and version is to run this query:

SELECT BANNER FROM V$VERSION;
-- Oracle version only:
SELECT BANNER FROM V$VERSION
    WHERE BANNER LIKE 'Oracle%';
-- PL/SQL version only:
SELECT BANNER FROM V$VERSION
    WHERE BANNER LIKE 'PL/SQL%';

This will work on any Oracle version. If the version is 18.1 or newer and you want more details, you can also select the BANNER_FULL column.

If you want more extensive information about the present instance, you can query V$INSTANCE.

Reference