How To Know which Oracle version is running (Oracle)

If you want to know which the exact Oracle Database version is running, you can find this by running the following query:

SELECT * FROM PRODUCT_COMPONENT_VERSION;

This will give you the installed version details.

Is very useful when you are requesting support from oracle, they will ask for this, or when you are connected to a database but do not know details about it.

The details about this are here.