Skip to content

Oracle NLS_TERRITORY All Available List

  • by

To retrieve all available NLS_TERRITORY in Oracle, we execute the following query to get the list.

SQL> select value "NLS_TERRITORY" from v$nls_valid_values where parameter = 'TERRITORY' AND isdeprecated = 'FALSE' order by 1;
Oracle All Available NLS_TERRITORY
NLS_TERRITORY
AFGHANISTAN
ALBANIA
ALGERIA
AMERICA
ANGOLA
ANTIGUA AND BARBUDA
ARGENTINA
ARMENIA
ARUBA
AUSTRALIA
AUSTRIA
AZERBAIJAN
BAHAMAS
BAHRAIN
BANGLADESH
BARBADOS
BELARUS
BELGIUM
BELIZE
BERMUDA
BOLIVIA
BOSNIA AND HERZEGOVINA
BOTSWANA
BRAZIL
BULGARIA
CAMBODIA
CAMEROON
CANADA
CATALONIA
CAYMAN ISLANDS
CHILE
CHINA
COLOMBIA
CONGO BRAZZAVILLE
CONGO KINSHASA
COSTA RICA
CROATIA
CURACAO
CYPRUS
CZECH REPUBLIC
DENMARK
DJIBOUTI
DOMINICA
DOMINICAN REPUBLIC
ECUADOR
EGYPT
EL SALVADOR
ESTONIA
ETHIOPIA
FINLAND
FRANCE
FYR MACEDONIA
GABON
GERMANY
GHANA
GREECE
GRENADA
GUATEMALA
GUYANA
HAITI
HONDURAS
HONG KONG
HUNGARY
ICELAND
INDIA
INDONESIA
IRAN
IRAQ
IRELAND
ISRAEL
ITALY
IVORY COAST
JAMAICA
JAPAN
JORDAN
KAZAKHSTAN
KENYA
KOREA
KUWAIT
LAOS
LATVIA
LEBANON
LIBYA
LIECHTENSTEIN
LITHUANIA
LUXEMBOURG
MACAO
MALAWI
MALAYSIA
MALDIVES
MALTA
MAURITANIA
MAURITIUS
MEXICO
MOLDOVA
MONTENEGRO
MOROCCO
MOZAMBIQUE
NAMIBIA
NEPAL
NEW ZEALAND
NICARAGUA
NIGERIA
NORWAY
OMAN
PAKISTAN
PANAMA
PARAGUAY
PERU
PHILIPPINES
POLAND
PORTUGAL
PUERTO RICO
QATAR
ROMANIA
RUSSIA
SAINT KITTS AND NEVIS
SAINT LUCIA
SAUDI ARABIA
SENEGAL
SERBIA
SIERRA LEONE
SINGAPORE
SLOVAKIA
SLOVENIA
SOMALIA
SOUTH AFRICA
SOUTH SUDAN
SPAIN
SRI LANKA
SUDAN
SURINAME
SWAZILAND
SWEDEN
SWITZERLAND
SYRIA
TAIWAN
TANZANIA
THAILAND
THE NETHERLANDS
TRINIDAD AND TOBAGO
TUNISIA
TURKEY
TURKMENISTAN
UGANDA
UKRAINE
UNITED ARAB EMIRATES
UNITED KINGDOM
URUGUAY
UZBEKISTAN
VENEZUELA
VIETNAM
YEMEN
ZAMBIA
ZIMBABWE

There're 155 NLS_LANGUAGE in total.

Leave a Reply

Your email address will not be published.