Database Reference
In-Depth Information
Figure 8.8
The Equals Sign Is
Now the Column
Separator.
command on a line above the query, changing the column separator to an
equals sign.
SET COLSEP =
Figure 8.8 shows the result. Notice that the SET command appears just
above the query in the top pane of the worksheet. The column separator (=)
appears between the column headings and between each column in each
row of data in the report.
We could add SET FEEDBACK OFF such that the text “… rows
selected.” does not appear at the end of the returned rows. Additionally, we
can change the page size to repeat headings more often. If printed, there
would be a page feed at the end of each page and headings at the start of
each printed page. Figure 8.9 shows the result.
SET FEEDBACK OFF PAGESIZE 20;
There is just one more thing: Generally, I use SQL*Plus for administra-
tion. I find the default wrapping and page width settings of ON and 80,
respectively, extremely irritating. On every client machine I use, assuming I
am not stepping on anyone else's toes, I add the line SET WRAP OFF
 
Search WWH ::




Custom Search