NLS_LANGon Windows in SQL*Plus.
First, it can be verified if the environment variable
NLS_LANG is set:
SQL*Plus will answer with either something similar to
In the first case, the environment variable is set and its value, as displayed by the
echo command is the value for
If the variable is not set, that is in the second case, the following trick allows to determine its value none the less:
There are again two possibilities how SQL*Plus will react. Either
In the first case, the value for NLS_LANG is set in the Windows registry (to the value between [ and ]). In the second case, NLS_LANG is not even set in the Windows registry.
Incidentally, this seems to be achieved much easier like so