December 2002
Intermediate to advanced
928 pages
85h 29m
English
By default, SQL*Plus will print one blank line between each page of output. That blank line, added to the PAGESIZE setting, must equal the physical size of the pages in your printer.
The SET PAGESIZE command may be used to control the number of lines SQL*Plus prints on a page. SET NEWPAGE controls the action of SQL*Plus when a page break occurs. You can change the number of blank lines between pages by using a command such as this:
SET NEWPAGE 10
You can tell SQL*Plus to display one form-feed character between pages by specifying SET NEWPAGE 0.
Newer releases of SQL*Plus also allow SET NEWPAGE NONE, which eliminates both blank lines and form-feed characters from between pages.