ALTER SESSIONName ALTER SESSION
-- change a run-time parameter
SynopsisALTER SESSION SET name = { value | 'value' };
Description The ALTER SESSION changes run-time configuration parameters.
ALTER SESSION only affects the value used by the current session.
The ALTER SESSION command and its associated run-time parameters are provided for
Redwood syntax compatibility. Some of these parameters are provided solely for
syntax compatibility and have no effect whatsoever on the run-time behavior of EnterpriseDB.
Others will alter a corresponding EnterpriseDB database server run-time configuration parameter.
See Section 30.4.
Parameters - name
Name of a settable run-time parameter. Available parameters are listed below.
- value
New value of parameter.
Configuration Parameters The following configuration parameters can be modified using the ALTER SESSION command:
- NLS_DATE_FORMAT(string)
Sets the display format for date and time values, as well as the rules for interpreting ambiguous
date input values. Has the same effect as setting the datestyle run-time configuration parameter.
See Section 30.4.11.2.
- NLS_LANGUAGE(string)
Sets the language in which messages are displayed.
Has the same effect as setting the lc_messages run-time configuration parameter.
See Section 30.4.11.2.
- NLS_LENGTH_SEMANTICS(string)
Valid values are BYTE and CHAR. The default is BYTE.
This parameter is provided for syntax compatibility only and has no effect in EnterpriseDB.
- QUERY_REWRITE_ENABLED(string)
Valid values are TRUE, FALSE, and FORCE.
The default is FALSE. This parameter is provided for syntax compatibility only and
has no effect in EnterpriseDB.
- QUERY_REWRITE_INTEGRITY(string)
Valid values are ENFORCED, TRUSTED, and STALE_TOLERATED.
The default is ENFORCED. This parameter is provided for syntax compatibility only and has no
effect in EnterpriseDB.
Examples ALTER SESSION SET NLS_LANGUAGE = 'en_US.UTF-8';
ALTER SESSION SET NLS_DATE_FORMAT = 'dd/mm/yyyy';
| 