Database Reference
In-Depth Information
SQL*Plus has a group of settings that define various aspects of your
working environment. These settings, as a group, are called
environmental
settings
. For example, the default setting for the width of the screen output
is 1,024 characters when using SQL*Plus Worksheet.
There are well in excess of 70 different environmental variables you can
set. Most environmental variables are SQL*Plus variables you adjust for
your Oracle Database 10
session and can only be used with SQL*Plus
tools (i.e., SQL*Plus, SQL*Plus Worksheet, and iSQL*Plus).
Look at the entire list by running the following statement in SQL*Plus
Worksheet:
g
SHOW ALL
Figure 8.1 shows part of the results.
Figure 8.1
Environmental
Variables, Settings,
and Some
Explanations.
