You can use the ALTER SESSION SQL command to override the NLS defaults. For example, suppose you create some parameters (such as language, territory, etc.), and a user specifies values for them: you could then alter the session as they specified.
Note: At runtime, the server executes an ALTER SESSION command on behalf of the client based on the values specified in NLS_LANG. If NLS_LANG is not defined, the ALTER SESSION statement is not executed.
In Oracle Forms, you can specify any of the following NLS parameters for the ALTER SESSION command. However, for Reports and Graphics, you can only specify the NLS_SORT parameter.
Parameter |
Description |
---|---|
NLS_LANGUAGE |
Language used by the server to return messages and errors |
NLS_TERRITORY |
Territory used for default date and currency masks |
NLS_DATE_FORMAT |
Default format used for dates |
NLS_DATE_LANGUAGE |
Default language used for dates |
NLS_NUMERIC_CHARACTERS |
Decimal character and group separator |
NLS_ISO_CURRENCY |
ISO international currency symbol |
NLS_CURRENCY |
Local currency symbol |
NLS_SORT |
Character sort sequence |
NLS_CALENDAR |
Current calendar system |