NLS_LANGUAGE to NLS_TERRITORY
Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this mapping table to solve globalization problems.
In order to change NLS_TERRITORY, you can change NLS_LANGUAGE by setting the environment variable NLS_LANG at OS-level, database sessions will use the value to change NLS_TERRITORY.
Mapping Table
| NLS_LANGUAGE | NLS_TERRITORY |
|---|---|
| ALBANIAN | ALBANIA |
| AMERICAN | AMERICA |
| AMHARIC | ETHIOPIA |
| ARABIC | UNITED ARAB EMIRATES |
| ARMENIAN | ARMENIA |
| ASSAMESE | INDIA |
| AZERBAIJANI | AZERBAIJAN |
| BANGLA | INDIA |
| BASQUE | SPAIN |
| BELARUSIAN | BELARUS |
| BRAZILIAN PORTUGUESE | BRAZIL |
| BULGARIAN | BULGARIA |
| CANADIAN FRENCH | CANADA |
| CATALAN | CATALONIA |
| CROATIAN | CROATIA |
| CYRILLIC KAZAKH | KAZAKHSTAN |
| CYRILLIC SERBIAN | SERBIA |
| CYRILLIC UZBEK | UZBEKISTAN |
| CZECH | CZECH REPUBLIC |
| DANISH | DENMARK |
| DARI | AFGHANISTAN |
| DIVEHI | MALDIVES |
| DUTCH | THE NETHERLANDS |
| EGYPTIAN | EGYPT |
| ENGLISH | UNITED KINGDOM |
| ESTONIAN | ESTONIA |
| FINNISH | FINLAND |
| FRENCH | FRANCE |
| GERMAN | GERMANY |
| GERMAN DIN | GERMANY |
| GREEK | GREECE |
| GUJARATI | INDIA |
| HEBREW | ISRAEL |
| HINDI | INDIA |
| HUNGARIAN | HUNGARY |
| ICELANDIC | ICELAND |
| INDONESIAN | INDONESIA |
| IRISH | IRELAND |
| ITALIAN | ITALY |
| JAPANESE | JAPAN |
| KANNADA | INDIA |
| KHMER | CAMBODIA |
| KOREAN | KOREA |
| LAO | LAOS |
| LATIN AMERICAN SPANISH | AMERICA |
| LATIN BOSNIAN | BOSNIA AND HERZEGOVINA |
| LATIN SERBIAN | SERBIA |
| LATIN UZBEK | UZBEKISTAN |
| LATVIAN | LATVIA |
| LITHUANIAN | LITHUANIA |
| MACEDONIAN | FYR MACEDONIA |
| MALAY | MALAYSIA |
| MALAYALAM | INDIA |
| MALTESE | MALTA |
| MARATHI | INDIA |
| MEXICAN SPANISH | MEXICO |
| NEPALI | NEPAL |
| NORWEGIAN | NORWAY |
| ORIYA | INDIA |
| PERSIAN | IRAN |
| POLISH | POLAND |
| PORTUGUESE | PORTUGAL |
| PUNJABI | INDIA |
| ROMANIAN | ROMANIA |
| RUSSIAN | RUSSIA |
| SIMPLIFIED CHINESE | CHINA |
| SINHALA | SRI LANKA |
| SLOVAK | SLOVAKIA |
| SLOVENIAN | SLOVENIA |
| SPANISH | SPAIN |
| SWAHILI | KENYA |
| SWEDISH | SWEDEN |
| TAMIL | INDIA |
| TELUGU | INDIA |
| THAI | THAILAND |
| TRADITIONAL CHINESE | TAIWAN |
| TURKISH | TURKEY |
| TURKMEN | TURKMENISTAN |
| UKRAINIAN | UKRAINE |
| URDU | PAKISTAN |
| VIETNAMESE | VIETNAM |
For more explanations on format elements, please refer to Oracle 19c SQL Language Reference: Datetime Format Models.