NLS (National Language Support)

NLS-region language support, used to define the date format, counting method, currency unit, language settings, and other options of the user's region. For example, for the region settings in mainland China, see.

 

With the use of NLS technology, you can change the currency symbol from$Convert￥, Language fromEnglishConvertChinese. In this way, you can use your native language to interact with Oracle and follow the user's data display conventions.

The following SQL example demonstrates the NLS Parameter Function.

● Client Parameters)

You can use the alter session command to change this parameter.

SQL> SELECT * FROM nls_session_parameters;
 
PARAMETER VALUE
---------------------------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT dd-mon-yy
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH. MI. SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH. MI. SSXFF AM
NLS_TIME_TZ_FORMAT HH. MI. SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH. MI. SSXFF AM TZR
NLS_DUAL_CURRENCY RMB
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
 
17 rows selected
 

● Instance Parameters)

You can use the alter system command to change this parameter.

SQL> SELECT * FROM nls_instance_parameters;
 
Parameter Value
-------------------------------------------------------------
Nls_language American
Nls_territory America
Nls_sort
Nls_date_language
Nls_date_format
Nls_currency
NLS_NUMERIC_CHARACTERS
NLS_ISO_CURRENCY
NLS_CALENDAR
NLS_TIME_FORMAT
NLS_TIMESTAMP_FORMAT
NLS_TIME_TZ_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_DUAL_CURRENCY
NLS_COMP
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
 
17 rows selected

 ● Database Parameters)

Set during database creation.

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
 
PARAMETER VALUE
-------------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET ZHS16GBK
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH. MI. SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH. MI. SSXFF AM
NLS_TIME_TZ_FORMAT HH. MI. SSXFF AM TZR
Nls_timestamp_tz_format DD-MON-RR HH. Mi. ssxff am tzr
Nls_dual_currency $
Nls_comp binary
Nls_length_semantics byte
Nls_nchar_conv_excp false
Nls_nchar_characterset al16utf16
Nls_rdbms_version 10.2.0.1.0
 
20 rows selected

Note:

Note that the three parameters have a priority relationship.Session ParametersPriority

The parameter set at the Session level is enabled first.

SESSION> INSTANCE> DATABASE