If you are building a multilingual application, it is important to understand how globalization codes affect the way in which your application runs. These codes are set automatically based on the application-level Globalization attributes you select.
NLS_LANGUAGE
and NLS_TERRITORY
determine the default presentation of numbers, dates, and currencies.
Table 18-6 describes the globalization codes in Oracle Application Express.
Table 18-6 Oracle Application Express Globalization Codes
Language Name | Language Code | NLS_LANGUAGE | NLS_TERRITORY |
---|---|---|---|
Afrikaans |
|
ENGLISH |
SOUTH AFRICA |
Arabic |
|
ARABIC |
UNITED ARAB EMIRATES |
Arabic (Algeria) |
|
ARABIC |
ALGERIA |
Arabic (Bahrain) |
|
ARABIC |
BAHRAIN |
Arabic (Egypt) |
|
EGYPTIAN |
EGYPT |
Arabic (Iraq) |
|
ARABIC |
IRAQ |
Arabic (Jordan) |
|
ARABIC |
JORDAN |
Arabic (Kuwait) |
|
ARABIC |
KUWAIT |
Arabic (Lebanon |
|
ARABIC |
LEBANNON |
Arabic (Libya) |
|
ARABIC |
LIBYA |
Arabic (Morocco) |
|
ARABIC |
MOROCCO |
Arabic (Oman) |
|
ARABIC |
OMAN |
Arabic (Qatar) |
|
ARABIC |
QATAR |
Arabic (Saudi Arabia) |
|
ARABIC |
SAUDI ARABIA |
Arabic (Syria) |
|
ARABIC |
SYRIA |
Arabic (Tunisia) |
|
ARABIC |
TUNISIA |
Arabic (U.A.E.) |
|
ARABIC |
UNITED ARAB EMIRATES |
Arabic (YEMEN) |
|
ARABIC |
YEMEN |
Assamese |
|
ASSAMESE |
INDIA |
Basque |
|
FRENCH |
FRANCE |
Belarusian |
|
RUSSIAN |
RUSSIA |
Bengali |
|
BANGLA |
BANGLADESH |
Bulgarian |
|
BULGARIAN |
BULGARIA |
Catalan |
|
CATALAN |
CATALONIA |
Chinese |
|
SIMPLIFIED CHINESE |
CHINA |
Chinese (China) |
|
SIMPLIFIED CHINESE |
CHINA |
Chinese (Hong Kong SAR) |
|
TRADITIONAL CHINESE |
HONG KONG |
Chinese (Macau SAR) |
|
TRADITIONAL CHINESE |
HONG KONG |
Chinese (Singapore) |
|
SIMPLIFIED CHINESE |
SINGAPORE |
Chinese (Taiwan) |
|
TRADITIONAL CHINESE |
TAIWAN |
Croatian |
|
CROATIAN |
CROATIA |
Czech |
|
CZECH |
CZECH REPUBLIC |
Danish |
|
DANISH |
DENMARK |
Dutch (Belgium) |
|
DUTCH |
BELGIUM |
Dutch (Netherlands) |
|
DUTCH |
THE NETHERLANDS |
English |
|
AMERICAN |
AMERICA |
English (Australia) |
|
ENGLISH |
AUSTRALIA |
English (Belize) |
|
ENGLISH |
UNITED KINGDOM |
English (Canada) |
|
ENGLISH |
CANADA |
English (Ireland) |
|
ENGLISH |
IRELAND |
English (Jamaica) |
|
ENGLISH |
UNITED KINGDOM |
English (New Zealand) |
|
ENGLISH |
NEW ZEALAND |
English (Philippines) |
|
ENGLISH |
PHILIPPINES |
English (South Africa) |
|
ENGLISH |
SOUTH AFRICA |
English (Trinidad) |
|
ENGLISH |
UNITED KINGDOM |
English (United Kingdom) |
|
ENGLISH |
UNITED KINGDOM |
English (United States) |
|
AMERICAN |
AMERICA |
English (Zimbabwe) |
|
ENGLISH |
UNITED KINGDOM |
Estonian |
|
ESTONIAN |
ESTONIA |
Faeroese |
|
ENGLISH |
UNITED KINGDOM |
Farsi |
|
ENGLISH |
UNITED KINGDOM |
Finnish |
|
FINNISH |
FINLAND |
French (Belgium) |
|
FRENCH |
BELGIUM |
French (Canada) |
|
CANADIAN FRENCH |
CANADA |
French (France) |
|
FRENCH |
FRANCE |
French (Luxembourg) |
|
FRENCH |
LUXEMBOURG |
French (Monaco) |
|
FRENCH |
FRANCE |
French (Switzerland) |
|
FRANCH |
SWITZERLAND |
FYRO Macedonian |
|
MACEDONIAN |
FYR MACEDONIA |
Gaelic |
|
ENGLISH |
UNITED KINGDOM |
Galician |
|
SPANISH |
SPAIN |
German (Austria) |
|
GERMAN |
AUSTRIA |
German (Germany) |
|
GERMAN |
GERMANY |
German (Liechtenstein) |
|
GERMAN |
GERMANY |
German (Luxembourg) |
|
GERMAN |
LUXEMBOURG |
German (Switzerland) |
|
GERMAN |
SWITZERLAND |
Greek |
|
GREEK |
GREECE |
Gujarati |
|
GUJARATI |
INDIA |
Hebrew |
|
HEBREW |
ISRAEL |
Hindi |
|
HINDI |
INDIA |
Hungarian |
|
HUNGARIAN |
HUNGARY |
Icelandic |
|
ICELANDIC |
ICELAND |
Indonesian |
|
INDONESIAN |
INDONESIA |
Italian (Italy) |
|
ITALIAN |
ITALY |
Italian (Switzerland) |
|
ITALIAN |
SWITZERLAND |
Japanese |
|
JAPANESE |
JAPAN |
Kannada |
|
KANNADA |
INDIA |
Kazakh |
|
CYRILLIC KAZAKH |
KAZAKHSTAN |
Konkani |
|
KOREAN |
KOREA |
Korean |
|
KOREAN |
KOREA |
Kyrgyz |
|
RUSSIAN |
RUSSIA |
Latvian |
|
LATVIAN |
LATVIA |
Lithuanian |
|
LITHUANIAN |
LITHUANIANA |
Malay (Malaysia) |
|
MALAY |
MALAYSIA |
Malayalam |
|
MALAYALAM |
INDIA |
Maltese |
|
ENGLISH |
UNITED KINGDOM |
Marathi |
|
ENGLISH |
INDIA |
Nepali (India) |
|
ENGLISH |
UNITED KINGDOM |
Norwegian (Bokmal) |
|
NORWEGIAN |
NORWAY |
Norwegian (Bokmal) |
|
NORWEGIAN |
NORWAY |
Norwegian (Nynorsk) |
|
NORWEGIAN |
NORWAY |
Oriya |
|
ORIYA |
INDIA |
Polish |
|
POLISH |
POLAND |
Portuguese (Brazil) |
|
BRAZILIAN PORTUGUESE |
BRAZIL |
Portuguese (Portugal) |
|
PORTUGUESE |
PORTUGAL |
Punjabi |
|
PUNJABI |
INDIA |
Romanian |
|
ROMANIAN |
ROMANIA |
Russian |
|
RUSSIAN |
RUSSIA |
Russian (Moldova) |
|
RUSSIAN |
RUSSIA |
Serbia |
|
CYRILLIC SERBIAN |
SERBIA AND MONTENEGRO |
Slovak |
|
SLOVAK |
SLOVAKIA |
Slovenian |
|
SLOVENIAN |
SLOVENIA |
Spanish (Argentina) |
|
LATIN AMERICAN SPANISH |
ARGENTINA |
Spanish (Bolivia) |
|
LATIN AMERICAN SPANISH |
ARGENTINA |
Spanish (Chile) |
|
LATIN AMERICAN SPANISH |
CHILE |
Spanish (Columbia) |
|
LATIN AMERICAN SPANISH |
COLUMBIA |
Spanish (Costa Rica) |
|
LATIN AMERICAN SPANISH |
COSTA RICA |
Spanish (Dominican Republic) |
|
LATIN AMERICAN SPANISH |
PUERTO RICO |
Spanish (Ecuador) |
|
LATIN AMERICAN SPANISH |
ECUDOR |
Spanish (El Salvador) |
|
LATIN AMERICAN SPANISH |
EL SALVADOR |
Spanish (Guatemala) |
|
LATIN AMERICAN SPANISH |
GUATEMALA |
Spanish (Honduras) |
|
LATIN AMERICAN SPANISH |
GUATEMALA |
Spanish (Mexico) |
|
MEXICAN SPANISH |
MEXICO |
Spanish (Nicaragua) |
|
LATIN AMERICAN SPANISH |
Nicaragua |
Spanish (Panama) |
|
LATIN AMERICAN SPANISH |
Panama |
Spanish (Paraguay) |
|
LATIN AMERICAN SPANISH |
ARGENTINA |
Spanish (Peru) |
|
LATIN AMERICAN SPANISH |
PERU |
Spanish (Puerto Rico) |
|
LATIN AMERICAN SPANISH |
PUERTO RICO |
Spanish (Traditional Sort) |
|
LATIN AMERICAN SPANISH |
SPAIN |
Spanish (United States) |
|
LATIN AMERICAN SPANISH |
AMERICAN |
Spanish (Uruguay) |
|
LATIN AMERICAN SPANISH |
ARGENTINA |
Spanish (Venezuela) |
|
LATIN AMERICAN SPANISH |
VENEZUELA |
Swedish |
|
SWEDISH |
SWEDEN |
Swedish |
|
SWEDISH |
FINLAND |
Tamil |
|
TAMIL |
INDIA |
Telugu |
|
TELUGU |
INDIA |
Thai |
|
THAI |
THAILAND |
Turkish |
|
TURKISH |
TURKEY |
Ukrainian |
|
UKRAINIAN |
UKRAINE |
Urdu |
|
ENGLISH |
UNITED KINGDOM |
Uzbek |
|
LATIN UZBEK |
UZBEKISTAN |
Vietnamese |
|
VIETNAMESE |
VIETNAM |