Oracle Database - Globalization (Localization, NLS parameter)

> Database > Oracle Database

1 - About

Globalization support enables the storing, processing and retrieval of data in native languages.

The languages that can be stored in an Oracle database are encoded by Oracle Database-supported character sets.

Globalization support ensures that:

  • database utilities,
  • error messages,
  • sort order,
  • date,
  • time,
  • monetary,
  • numeric,
  • and calendar conventions

adjust to the native language and locale.

Advertising

3 - Parameters

NLS Parameter Goal
NLS_CHARACTERSET Define the characterset
NLS_CURRENCY
NLS_DATE_FORMAT Define the output format of a date
NLS_DATE_LANGUAGE
NLS_DUAL_CURRENCY
NLS_ISO_CURRENCY
NLS_LANGUAGE Define the language
NLS_LENGTH_SEMANTICS
NLS_LANG To Define in one parameter the NLS_TERRITORY and NLS_LANGUAGE values
NLS_NUMERIC_CHARACTERS decimal separator and thousands separator
NLS_SORT
NLS_TERRITORY If the parameters NLS_CURRENCY, NLS_DUAL_CURRENCY, NLS_ISO_CURRENCY, NLS_DATE_FORMAT, NLS_TIMESTAMP_FORMAT, NLS_TIMESTAMP_TZ_FORMAT, NLS_NUMERIC_CHARACTERS are not set, they are derived from NLS_TERRITORY
Advertising

4 - Data Dictionary

Applications can check the session, instance, and database NLS parameters by querying the following data dictionary views:

  • NLS_SESSION_PARAMETERS shows the NLS parameters and their values for the session that is querying the view. It does not show information about the character set.
  • NLS_INSTANCE_PARAMETERS shows the current NLS instance parameters that have been explicitly set and the values of the NLS instance parameters.
  • NLS_DATABASE_PARAMETERS shows the values of the NLS parameters for the database. The values are stored in the database.

Applications can check the following NLS dynamic performance views:

  • V$NLS_VALID_VALUES lists values for the following NLS parameters: NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, NLS_CHARACTERSET
  • V$NLS_PARAMETERS shows current values of the following NLS parameters: NLS_CALENDAR, NLS_CHARACTERSET, NLS_CURRENCY, NLS_DATE_FORMAT, NLS_DATE_LANGUAGE, NLS_ISO_CURRENCY, NLS_LANGUAGE, NLS_NUMERIC_CHARACTERS, NLS_SORT, NLS_TERRITORY, NLS_NCHAR_CHARACTERSET, NLS_COMP, NLS_LENGTH_SEMANTICS, NLS_NCHAR_CONV_EXP, NLS_TIMESTAMP_FORMAT, NLS_TIMESTAMP_TZ_FORMAT, NLS_TIME_FORMAT, NLS_TIME_TZ_FORMAT

5 - Documentation / Reference

Advertising
db/oracle/nls_parameter.txt · Last modified: 2017/09/06 19:28 by gerardnico