Database Reference
In-Depth Information
If you want to view only a single variable, use the SHOW command
with that variable's name as in SHOW { variable name }. For example, to
see the setting for PAGESIZE, type the following:
SHOW PAGES[IZE]
The page size can also be found using the abbreviation for PAGESIZE,
PAGES. Here is a list of some of the commonly used settings with their stan-
dard abbreviations (if any). Some of these environmental variables have
already been used in previous chapters, such as LINESIZE and HEADING.
Note:
Environmental settings usually have shortened versions for faster
access, some being as small as three characters.
AUTO[COMMIT]
. By default, AUTOCOMMIT is set to OFF. Set-
ting this variable to ON will commit all DML changes automatically.
If you ever plan to undo DML changes with a ROLLBACK com-
mand, do not tamper with this setting.
ARRAY[SIZE]
. Sets the number of rows SQL*Plus retrieves as a
block from the database. The default is 15 and the valid range is 1 to
5,000. Retrieving many rows at once can improve performance, but
Oracle advises that values higher than 100 do not help.
CMDS[EP]
. Sets the character that marks the end of a command
(command separator) when you allow multiple commands on one
line. The default is OFF, meaning you cannot have multiple com-
mands on one line. You can set it to ON, which allows multiple com-
mands on one line and sets the command separator to “;”. You can
also set it to a different character. For example, to set the command
separator to “
” and then use multiple commands on one line, exe-
cute these commands in SQL*Plus Worksheet:
~
SET CMDSEP ~
COL NAME HEADING "Artist" ~ COL CITY HEADING "Location"
SELECT NAME, CITY FROM ARTIST;
SET CMDSEP OFF
COLSEP
. Sets the character used between columns in a report. The
default is a blank space.
 
Search WWH ::




Custom Search