NLS_LANGUAGE

Property	Description
Parameter type	String
Syntax	NLS_LANGUAGE = language
Default value	Operating system-dependent, derived from the NLS_LANG environment variable
Modifiable	ALTER SESSION
Range of values	Any valid language name
Basic	Yes

NLS_LANGUAGE specifies the default language of the database. This 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:

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_LANGUAGE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
nls_language	AMERICAN	TRUE	TRUE	FALSE	FALSE	FALSE	NLS language name

Oracle initializatoin parameters