Territory overrides the value nls

Specifying Language-Dependent Behavior for the Session

•	Specify the locale behavior with the NLS_LANG environment variable:

•

16-15 Copyright © 2006, Oracle. All rights reserved.

NLS_LANG = _JAPAN
NLS_LANG = .US7ASCII

Oracle Database 10g: Administration Workshop II 16-15

Parameter	Default Values
NLS_LANGUAGE NLS_DATE_LANGUAGE NLS_SORT
NLS_TERRITORY NLS_CURRENCY NLS_DUAL_CURRENCY NLS_ISO_CURRENCY NLS_DATE_FORMAT NLS_NUMERIC_CHARACTERS NLS_TIMESTAMP_FORMAT NLS_TIMESTAMP_TZ_FORMAT

16-16 Copyright © 2006, Oracle. All rights reserved.

Language- and Territory-Dependent Parameters
Setting the NLS_LANGUAGE and NLS_TERRITORY initialization parameters determines the default values that should be used by the Oracle database. You can override these default values by explicitly setting the values for those initialization parameters whose default values depend on the settings of NLS_LANGUAGE and NLS_TERRITORY.


	Determines the language for day and month names and abbreviations and spelled values of other date format elements
NLS_SORT

Over 10 Million Study Resources Now at Your Fingertips