How to Return a List of Supported Languages in Oracle

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

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

Example

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

SELECT * FROM
V$NLS_VALID_VALUES
WHERE PARAMETER = 'LANGUAGE'
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 language name), and limits the results to just those languages that aren’t deprecated.

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

Result:

ALBANIAN                
AMERICAN                
AMHARIC                 
ARABIC                  
ARMENIAN                
ASSAMESE                
AZERBAIJANI             
BANGLA                  
BASQUE                  
BELARUSIAN              
BRAZILIAN PORTUGUESE    
BULGARIAN               
CANADIAN FRENCH         
CATALAN                 
CROATIAN                
CYRILLIC KAZAKH         
CYRILLIC SERBIAN        
CYRILLIC UZBEK          
CZECH                   
DANISH                  
DARI                    
DIVEHI                  
DUTCH                   
EGYPTIAN              
ENGLISH                   
ESTONIAN                  
FINNISH                   
FRENCH                    
GERMAN                    
GERMAN DIN                
GREEK                     
GUJARATI                  
HEBREW                    
HINDI                     
HUNGARIAN                 
ICELANDIC                 
INDONESIAN                
IRISH                     
ITALIAN                   
JAPANESE                  
KANNADA                   
KHMER                     
KOREAN                    
LAO                       
LATIN AMERICAN SPANISH    
LATIN BOSNIAN             
LATIN SERBIAN             
LATIN UZBEK
LATVIAN               
LITHUANIAN            
MACEDONIAN            
MALAY                 
MALAYALAM             
MALTESE               
MARATHI               
MEXICAN SPANISH       
NEPALI                
NORWEGIAN             
ORIYA                 
PERSIAN               
POLISH                
PORTUGUESE            
PUNJABI               
ROMANIAN              
RUSSIAN               
SIMPLIFIED CHINESE    
SINHALA               
SLOVAK                
SLOVENIAN             
SPANISH               
SWAHILI               
SWEDISH
TAMIL                  
TELUGU                 
THAI                   
TRADITIONAL CHINESE    
TURKISH                
TURKMEN                
UKRAINIAN              
URDU                   
VIETNAMESE