Skip to content

Oracle NLS_LANGUAGE All Available List

  • by
  • September 8, 2019June 14, 2022

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

SQL> select value "NLS_LANGUAGE" from v$nls_valid_values where parameter = 'LANGUAGE' AND isdeprecated = 'FALSE' order by 1;
Oracle All Available NLS_LANGUAGE
NLS_LANGUAGE
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

There're 81 NLS_LANGUAGE in total.

Leave a Reply

Your email address will not be published.