How to get the version of Oracle database using query?

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!

How to get the version of DB2 database using query?

Its very easy to get the version of DB2 database using a query. It works in most of the DB2 version.

We can execute the following query just as like any other queries and get the result.

SELECT service_level FROM TABLE(ENV_GET_INST_INFO()) AS TEMP;

Once you execute this query you will get a result set like this,



Hope this is useful!