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;
You may press Ctrl + d to bookmark this page.
| 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.