Below is a list of territories that are supported by Oracle Database. These can be used when setting the NLS_TERRITORY
initialization parameter.
- 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
- GEORGIA
- 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
- KYRGYZSTAN
- LAOS
- LATVIA
- LEBANON
- LIBYA
- LIECHTENSTEIN
- LITHUANIA
- LUXEMBOURG
- MACAO
- MALAWI
- MALAYSIA
- MALDIVES
- MALTA
- MAURITANIA
- MAURITIUS
- MEXICO
- MOLDOVA
- MONTENEGRO
- MOROCCO
- MOZAMBIQUE
- MYANMAR
- 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
You can check the value of your session’s NLS_TERRITORY
parameter like this:
SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER = 'NLS_TERRITORY';
You can set the parameter like this:
ALTER SESSION SET NLS_TERRITORY = 'AUSTRALIA';
This example sets the value to AUSTRALIA
, but you can use any of the territories listed above.
You can also get a list of territories by querying the V$NLS_VALID_VALUES
view:
SELECT * FROM
V$NLS_VALID_VALUES
WHERE PARAMETER = 'TERRITORY'
ORDER BY VALUE ASC;