How to check Oracle version via SQL query

You may use following query to check Oracle version:

SELECT * FROM product_component_version

Or this one:

SELECT * FROM v$version

Both will return Oracle version information.