NLS_TERRITORY

Property	Description
Parameter type	String
Syntax	NLS_TERRITORY = territory
Default value	Operating system-dependent
Modifiable	ALTER SESSION
Range of values	Any valid territory name
Basic	Yes

NLS_TERRITORY specifies the name of the territory whose conventions are to be followed for day and week numbering.

This parameter also establishes the default date format, the default decimal character and group separator, and the default ISO and local currency symbols.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘NLS_TERRITORY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_territory	AMERICA	TRUE	TRUE	FALSE	FALSE	FALSE	NLS territory name

Oracle initializatoin parameters