The NLS_DATE_LANGUAGE option specifies the language for days, months, and similar language-dependent datetime format elements.
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
.
TEXT
NLS_DATE_LANGUAGE = option-value
See Oracle Database Reference for more information about NLS parameters, including valid values.