Page Width and Length
Page width is controlled by the SET LINESIZE command. The default width is 80 characters. You can change it—to 60 characters, for example—by using the command like this:
SET LINESIZE 60
The LINESIZE setting is used by SQL*Plus to center and right-justify page headers and page footers.
Page length is controlled by the SET PAGESIZE command. The default is to print 24 lines per page, and this includes the page header and page footer lines. The following command changes the page length to 50 lines:
SET PAGESIZE 50
When using SET MARKUP HTML ON to generate HTML output, PAGESIZE controls the number of HTML table rows that display before column headings are repeated; each row may display as one or more physical lines depending on how the browser window is sized.
Setting PAGESIZE to 0 has a special meaning to SQL*Plus. A PAGESIZE of 0 will inhibit the display of page headers, page footers, and column headings.