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.