ORACLE 变量之 NLS_LANGUAGE

NLS_LANGUAGE

Property Description

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

NLS_LANGUAGEspecifies 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 parametersNLS_DATE_LANGUAGEandNLS_SORT.

Note:

The value of this initialization parameterNLS_LANGUAGEis 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 theNLS_LANGclient setting (environment variable) is defined. The initialization parameter value is, therefore, usually ignored.

OCP 题库考核内容

Q122. The NLS_LANGUAGEparameter specifiesthe default conventions to be used for which of the following globalization elements?

A. Languages for server messages

B. Day and month names and abbreviations

C. Symbols to represent a.m., p.m., AD, and BC

D. Affirmative and negative response strings (YES, NO)

E. None of the above

F. All of the above

Answer: F

一下三条语句分别用了查看数据库、实例、和用户会话的当前NLS值；

SELECT * from nls_database_parameters;

NLS_DATABASE_PARAMETERSlists permanent NLS parameters of the database.

SELECT * from nls_instance_parameters;

NLS_INSTANCE_PARAMETERSlists NLS parameters of the instance.

SELECT * from nls_session_parameters;

NLS_SESSION_PARAMETERSlists NLS parameters of the user session.