A script-enabled browser is required for this page to function properly.

Using ALTER SESSION

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