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