To retrieve all available NLS_LANGUAGE or NLS_DATE_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;You may press Ctrl + d to bookmark this page.
| 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.
To see how NLS_LANGUAGE changes other NLS settings, you may check the following post: