Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.7 ALTER SESSION

ALTER SESSION  --  change a runtime parameter
ALTER SESSION SET name = value
The ALTER SESSION command changes runtime configuration parameters. ALTER SESSION only affects the value used by the current session. Some of these parameters are provided solely for compatibility with Oracle syntax and have no effect whatsoever on the runtime behavior of Advanced Server. Others will alter a corresponding Advanced Server database server runtime configuration parameter.
Sets the language in which messages are displayed. Has the same effect as setting the Advanced Server lc_messages runtime configuration parameter.
Valid values are BYTE and CHAR. The default is BYTE. This parameter is provided for syntax compatibility only and has no effect in the Advanced Server.
Sets the default optimization mode for queries. Valid values are ALL_ROWS, CHOOSE, FIRST_ROWS, FIRST_ROWS_10, FIRST_ROWS_100, and FIRST_ROWS_1000. The default is CHOOSE. This parameter is implemented in Advanced Server. See Section 3.4 for more information about optimizer hints.
Valid values are TRUE, FALSE, and FORCE. The default is FALSE. This parameter is provided for syntax compatibility only and has no effect in Advanced Server.
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 Advanced Server.
Set the language to U.S. English in UTF-8 encoding. Note that in this example, the value, en_US.UTF-8, is in the format that must be specified for Advanced Server. This form is not compatible with Oracle databases.

3 The SQL Language : 3.3 SQL Commands : 3.3.7 ALTER SESSION

Table of Contents Previous Next