Databases Reference
In-Depth Information
Turning the column headings off may be useful, for example, when sending
the output of a SQL query to a file for processing by another program that may
not need to have the column headings.
HEADSEP
The
variable (Headings on Multiple Lines on the Script Formatting
page) allows column headings to appear on multiple lines in the output. A single
character, which is the vertical bar (
HEADSEP
|
) by default, divides the heading onto mul-
tiple lines. You can set the
HEADSEP
variable to either specify the separator char-
acter or turn on or off the
HEADSEP
feature. We'll talk more about
HEADSEP
later
in this chapter, in conjunction with the
COLUMN
command.
