How to check the Oracle database version?

To get detailed version number of the database components, you can try:

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE

or

BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_DB_VERSION.VERSION || '.' || DBMS_DB_VERSION.RELEASE); END;