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.
Articles Related
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 |
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:
- VNLS_VALID_VALUES lists values for the following NLS parameters: NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, NLS_CHARACTERSET
- VNLS_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