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
andNO
)
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';