How to check oracle client version.

October 8, 2020

SCRIPTS

Sometime we have to run the application script from application server, but the script required a defined oracle version to run the application script successfully.

Below are the Sql query to find the oracle client version.

SQL command to get oracle client version. Click here to get sample output.

SELECT
  DISTINCT
  s.client_version
FROM
  v$session_connect_info s
WHERE
  s.sid = SYS_CONTEXT('USERENV', 'SID');

We always encourage the technical person to visit section SCRIPTS to get more daily usage SQL commands.

Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.

DATABASE, SCRIPTS