How to Return a List of Supported Territories in Oracle

When using Oracle Database, you can find out what territories are supported by querying the V$NLS_VALID_VALUES view.

This view lists all valid values for NLS parameters, including supported territories.

Example

Here’s an example of querying the V$NLS_VALID_VALUES view to return a list of all territories supported in Oracle Database:

SELECT * FROM
V$NLS_VALID_VALUES
WHERE PARAMETER = 'TERRITORY'
ORDER BY VALUE ASC;

That returns all columns and all rows.

One of the columns returned indicates whether the language is deprecated or not.

Here’s another example that narrows the columns to just the VALUE column (which stores the territory name), and limits the results to just those territories that aren’t deprecated.

SELECT VALUE FROM
V$NLS_VALID_VALUES
WHERE PARAMETER = 'TERRITORY'
AND ISDEPRECATED = 'FALSE'
ORDER BY VALUE ASC;

Result:

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