The following table contains a list of territories that are supported by Oracle Database.

Language Name	Language Abbreviation	Default Sort
ALBANIAN	sq	GENERIC_M
AMERICAN	us	binary
AMHARIC	am	GENERIC_M
ARABIC	ar	ARABIC
ARMENIAN	hy	GENERIC_M
ASSAMESE	as	binary
AZERBAIJANI	az	AZERBAIJANI
BANGLA	bn	binary
BASQUE	eu	GENERIC_M
BELARUSIAN	be	RUSSIAN
BRAZILIAN PORTUGUESE	ptb	WEST_EUROPEAN
BULGARIAN	bg	BULGARIAN
BURMESE	my	GENERIC_M
CANADIAN FRENCH	frc	CANADIAN FRENCH
CATALAN	ca	CATALAN
CROATIAN	hr	CROATIAN
CYRILLIC KAZAKH	ckk	GENERIC_M
CYRILLIC SERBIAN	csr	GENERIC_M
CYRILLIC UZBEK	cuz	GENERIC_M
CZECH	cs	CZECH
DANISH	dk	DANISH
DARI	prs	GENERIC_M
DIVEHI	dv	GENERIC_M
DUTCH	nl	DUTCH
EGYPTIAN	eg	ARABIC
ENGLISH	gb	binary
ESTONIAN	et	ESTONIAN
FINNISH	sf	FINNISH
FRENCH	f	FRENCH
GEORGIAN	ka	GENERIC_M
GERMAN DIN	din	GERMAN
GERMAN	d	GERMAN
GREEK	el	GREEK
GUJARATI	gu	binary
HEBREW	iw	HEBREW
HINDI	hi	binary
HUNGARIAN	hu	HUNGARIAN
ICELANDIC	is	ICELANDIC
INDONESIAN	in	INDONESIAN
IRISH	ga	binary
ITALIAN	i	WEST_EUROPEAN
JAPANESE	ja	binary
KANNADA	kn	binary
KHMER	km	GENERIC_M
KOREAN	ko	binary
KYRGYZ	ky	GENERIC_M
LAO	lo	GENERIC_M
LATIN AMERICAN SPANISH	esa	SPANISH
LATIN BOSNIAN	lbs	GENERIC_M
LATIN SERBIAN	lsr	binary
LATIN UZBEK	luz	GENERIC_M
LATVIAN	lv	LATVIAN
LITHUANIAN	lt	LITHUANIAN
MACEDONIAN	mk	binary
MALAY	ms	MALAY
MALAYALAM	ml	binary
MALTESE	mt	GENERIC_M
MARATHI	mr	binary
MEXICAN SPANISH	esm	WEST_EUROPEAN
NEPALI	ne	GENERIC_M
NORWEGIAN	n	NORWEGIAN
ORIYA	or	binary
PERSIAN	fa	GENERIC_M
POLISH	pl	POLISH
PORTUGUESE	pt	WEST_EUROPEAN
PUNJABI	pa	binary
ROMANIAN	ro	ROMANIAN
RUSSIAN	ru	RUSSIAN
SIMPLIFIED CHINESE	zhs	binary
SINHALA	si	GENERIC_M
SLOVAK	sk	SLOVAK
SLOVENIAN	sl	SLOVENIAN
SPANISH	e	SPANISH
SWAHILI	sw	GENERIC_M
SWEDISH	s	SWEDISH
TAMIL	ta	binary
TELUGU	te	binary
THAI	th	THAI_DICTIONARY
TRADITIONAL CHINESE	zht	binary
TURKISH	tr	TURKISH
TURKMEN	tk	GENERIC_M
UKRAINIAN	uk	UKRAINIAN
URDU	ur	GENERIC_M
VIETNAMESE	vn	VIETNAMESE

These languages provide support for locale-sensitive information such as:

• Day and month names and their abbreviations
• Symbols for equivalent expressions for A.M., P.M., A.D., and B.C.
• Default sorting sequence for character data when the ORDER BY SQL clause is specified
• Writing direction (left to right or right to left)
• Affirmative and negative response strings (for example, YES and NO)

Return Your Own List

You can also run the following query to get a list of languages supported by your own system:

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

The V$NLS_VALID_VALUES dynamic performance view returns information about character sets, languages, territories, and linguistic sorts.

Note that the above table and view don’t include any additional languages that can be accessed when using Unicode databases and data types.

Check your Session’s Language

You can run a quick check of the language being used in your current session by querying the V$NLS_PARAMETERS view:

SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER = 'NLS_LANGUAGE';

You should probably also check the NLS_DATE_LANGUAGE parameter, to see if it has been explicitly set to a different language:

SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER = 'NLS_DATE_LANGUAGE';