How to check the database version in Oracle

Confirm the exact database release and component versions before and after patching.

-- Banner and release (all versions)
SELECT * FROM v$version;

SELECT product, version, status
FROM   product_component_version;

-- 18c and later: exact RU in VERSION_FULL
-- SELECT instance_name, version, version_full, status FROM v$instance;