Oracle server and client query script (lazy Version)

This script can be used to identify the character set of the Oracle server in PLSQL and display the local Oracle client characters in the CMD window.
The following script can be directly copied to the PLSQL command window to run. If there is a better script, post it. THX.

Cl
-- Query nls_rjage_nls_territory.nls_characterset from V $ nls_parameters
Select 'HKEY _ LOCAL_MACHINE \ Software \ oracle \ home0 \ nls_lang 'as client, t1.value |' _ '| t2.value | '. '| t3.value as server from V $ nls_parameters T1, V $ nls_parameters T2, V $ nls_parameters T3
Where t1.parameter = 'nls _ language'
And t2.parameter = 'nls _ territory'
And t3.parameter = 'nls _ characterset ';

Prompt -------------------------------------------------------
Prompt querying Oracle client charset from Windows registry:
Prompt -------------------------------------------------------
Prompt Oracle client charset has been displayed in cmd window.

$ Cmd/K echo Oracle client charset & reg query HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ home0/V nls_lang | find "nls_lang"