Database Reference
In-Depth Information
Enter before issuing a page break and displaying the next screen of
data.
RECSEP
. Can be set to WRAPPED to output a record separator
when a line wraps. Set to OFF to disable and EACH to include a
record separator for every line.
RECSEPCHAR
. This option allows resetting of the record separator.
Using the code following, Figure 8.4 changes the record separator
and separates each record with a line containing asterisks (*):
SET RECSEPCHAR '*'
SET RECSEP EACH
SELECT * FROM ARTIST;
SERVEROUT[PUT]
. Turns on or off the ability to display messages
on your screen. Use SET SERVEROUTPUT OFF when executing
scripts generating code into a spooled file; messages are suppressed.
Figure 8.4
Separating Records.
 
Search WWH ::




Custom Search