How does Oracle maintain Oracle Client software? I don't find Patch Updates for the Client Software of Oracle.
Oracle Client – Do I Need to Update?
clientodbcoracleoracle-12c
Related Solutions
I am a little doubtful that this is exactly what you are looking for, but
host echo %nls_lang%;
ENGLISH_UNITED KINGDOM.WE8ISO8859P1
shows the client nls_lang environment variable on the client.
I don't think there will be a SQL query you can run to give the 'current' setting because AFAIK the server is not aware of what translation is done client-side, so any command to show the current setting will have to be native to the client - I used SQL Developer for the above command, but I assume it will work the same in SQL*Plus
--edit
only the client knows their character set as well -- it is not available "in the database"
the character set describes what is stored in database.
the client makes their desired translated to character know [sic] to the database via the NLS_LANG settting.
If you were on 11.1+, you might have some joy with v$session_connect_info, because:
This information is pushed by OCI to the server ats login time.
But I discovered it would still depend on how you are connecting, eg from the JDBC Thin Driver you aren't using OCI and so the information isn't pushed
The public link below gives an overview of the four installation type options for the 11gR2 client:
http://docs.oracle.com/cd/E11882_01/install.112/e24322/install_overview.htm#LACLI1245
Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), Pro*C, or Java database connectivity (JDBC) OCI applications. This installation type requires much less disk space than the other Oracle Client installation types.
Administrator: Enables applications to connect to an Oracle Database instance on the local system or on a remote system. It also provides tools that enable you to administer Oracle Database.
Runtime: Enables applications to connect to an Oracle Database instance on the local system or on a remote system.
Custom: Enables you to select individual components from the list of Administrator and Runtime components.
A complete list of which individual components are installed by which Installation Type can be found on My Oracle Support, Doc ID [1397346.1]. It also includes the different components that are installed only on Microsoft Windows and not on other platforms.
Because My Oracle Support requires an Oracle account to login and access this information, I do not believe it is allowed to be posted on public forums. However, if you already have a support account with Oracle, you can go to https://support.oracle.com to login and search for the Document ID posted above to reference the complete list of components included in each Installation Type as you requested.
EDIT: Also, to answer your second question, yes, "Oracle Data Provider for .NET" is the ODP.NET component.
Best Answer
A client-only installation is similar to a database server installation, but it has a reduced set of components. It can be patched with the database PSU/RU.
E.g. this is from the readme of the 11.2.0.4.180417 database PSU (11g, because the latest 12c readme does not have a similar section):
Instant Client installations can not be patched with the same method, for that see: How to Apply a Patch to an Oracle Instant Client Installation? (Doc ID 1072125.1)