1.206 NLS_LANGUAGE
NLS_LANGUAGE
specifies the default language of the database.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
Operating system-dependent, derived from the |
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
Any valid language name |
Basic |
Yes |
This language specified by NLS_LANGUAGE
is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. This parameter also determines the default values of the parameters NLS_DATE_LANGUAGE
and NLS_SORT
.
Note:
The value of this initialization parameter NLS_LANGUAGE
is used to initialize the session value of this parameter, which is the actual value referenced by the SQL query processing. This initial value is overridden by a client-side value if the client uses the Oracle JDBC driver or if the client is OCI-based and the NLS_LANG
client setting (environment variable) is defined. The initialization parameter value is, therefore, usually ignored.
Examples
See these examples of using the NLS_LANGUAGE
parameter:
-
For an example of setting
NLS_LANGUAGE
to Italian, see Oracle Database Globalization Support Guide. -
For an example of overriding default values for
NLS_LANGUAGE
andNLS_TERRITORY
during a session, see Oracle Database Globalization Support Guide.
See Also:
-
Oracle Database Globalization Support Guide for more information about this parameter.
-
Oracle Database Globalization Support Guide for a complete list of languages that can be specified using this parameter
-
Oracle Database Globalization Support Guide for information on overriding the default values for this parameter
-
Your operating system-specific Oracle documentation and the release notes for your country