Check client connected character set to the Oracle Database

SELECT DISTINCT SID, CLIENT_CHARSET FROM V$SESSION_CONNECT_INFO;

       SID CLIENT_CHARSET
---------- -------------------------
       103 JA16SJIS
       202 WE8MSWIN1252

Check Client Software version connected to Oracle Database

SELECT DISTINCT SID, CLIENT_VERSION FROM V$SESSION_CONNECT_INFO;

       SID CLIENT_VERSION
---------- --------------------------
       103 12.1.0.2.0
       202 18.4.0.0.0

Check client driver or software from which connection established to Oracle database.

SELECT DISTINCT SID, client_driver FROM V$SESSION_CONNECT_INFO;

       SID CLIENT_DRIVER
---------- --------------------------
       202 SQL*PLUS
       103 SQL*PLUS