The NLS_LANGUAGE option specifies the current language for the session. the setting of this option determines the value of the SESSION_NLS_LANGUAGE option.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSION SET option = value.
See Oracle Database Globalization Support Guide for more information about NLS database parameters.
Example 5-76 Effects of Changing NLS_LANGUAGE
In this example, the NLS_LANG option is initially set to:
AMERICAN_AMERICA.WE8ISO8859P1
The value of YESSPELL is yes.
A change to the language setting:
NLS_LANGUAGE = 'FRENCH'
changes the value of NLS_LANG to
FRENCH_AMERICAN.WE8ISO8859P1
The value of YESSPELL is now oui.