Its very easy to get the version of Oracle database using a query. It works in most of the Oracle version.
We can execute the following query just as like any other queries and get the result.
SELECT * FROM v$version WHERE banner LIKE 'Oracle%';
Once you execute this query you will get a result set like this,
Hope this is useful!
