How to find the exact Oracle Database and Install Component Version Numbers

When you log on to an Oracle Database with SQL*Plus the version number is normally displayed for you. However what about the other components or what if I'm using another tool?

The following query gives the version numbers of the database and the installed components.

SELECT 'Version' source,
banner
FROM sys.v_$version
UNION ALL
SELECT 'Registry',
banner
FROM sys.all_registry_banners

Done...