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