SYNTAX
SET parameter value parameter value ...
DESCRIPTION
SET command configures session's environment allowing user to customize it.
There are SQL Plus parameters that are supported for compatibility with
old SQL Plus/Server manager scripts
(ECHO TERMOUT FEEDBACK HEADING SERVEROUTPUT )
There are also additional parameters.
PARAMETERS
| Parameter |
Value |
Description |
| STEP |
LOCAL | GLOBAL | OFF (default) |
Confirmation before executing each line of a script. Local enables this
only for current script. Global enables confirmation for all scripts.
|
| XECHO |
ON | OFF (default) |
Enables printing evaluated code ( {...}) before execution.
|
| CODEPAGE |
{OUT | IN } {ANSI | OEM} |
Applies to Windows only.
Defines the codepage used for console input or output.
By default Windows consoles use OEM codepages that come from DOS times.
But, usually GUI Windows programs use ANSI codepages.
Setting this parameter to OEM allows using in consoles
NLS_CHARACTERSET set to ANSI codepage. So you'll have the same NLS settings
for GUI and console applications. Scripts codepage not being affected by this
parameter.
You should set this parameter to OEM only if your client NLS_CHARACTERSET
parameter set to ANSI codepage.
|
EXAMPLE 1
SQL>set codepage out oem
SQL>set cp out dos
SQL>set cp out 850
Three lines above do the same things
SQL>set cp in ansi
SQL>set cp in 1250
Two lines above do the same things
|
