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:
adjust to the native language and locale.
| 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 |
Applications can check the session, instance, and database NLS parameters by querying the following data dictionary views:
Applications can check the following NLS dynamic performance views: