Other National Language Parameters
You can use a number of other national language parameters to indicate specific attributes of the national language setting:
NLS_CALENDAR indicates the calendar system used for the language.
NLS_CURRENCY indicates the local currency symbol.
NLS_DATE_FORMAT indicates the local date format.
NLS_DATE_LANGUAGE indicates the default language used for dates.
NLS_ISO_CURRENCY indicates the ISO international currency symbol.
NLS_SORT indicates the sort order for the language.
NLS_CALENDAR specifies which calendar system Oracle uses. It can have one of the following values:
For example, suppose NLS_CALENDAR is set to "Japanese Imperial", the date format is "E YY-MM-DD".
- Arabic Hijrah
- English Hijrah
- Japanese Imperial
- ROC Official (Republic of China)
- Thai Buddha
("E" is the date format element for the abbreviated era name.) If the date is May 15, 1997, then the SYSDATE is displayed as follows:
SELECT SYSDATE FROM DUAL;
Each of these can be set in the Oracle initialization file or on a session-by-session basis.
You do not have to set any of them unless you wish their values to be different from the normal values for