|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The PAGESIZE option specifies the size of a page of output. The value of PAGESIZE is the number of output lines to be produced on each page. PAGESIZE is usually used in the initialization section of report programs. The PAGESIZE option is meaningful only when PAGING is set to
YES and only for output from statements such as REPORT and LISTNAMES.
PAGESIZE = n
An integer expression that specifies the number of output lines on a page; n includes the top and bottom margins (controlled by the TMARGIN and BMARGIN options). The default is 66 lines, which is suitable for printing report output on 8 1/2" by 11" paper.
Output Lines Lines from PAGESIZE 66 Lines for TMARGIN - 2 Lines for the standard heading - 2 Lines for BMARGIN - 1 Lines available for output 61
You can produce pages with no headings by using the statement
PAGEPRG='NONE' or suppress page breaks entirely by using the statement
PAGING = NO.
When PAGING is set to
YES, you can force a page break at any point in a page of output by using a PAGE command.
When you set PAGESIZE for the default outfile, the new value remains in effect until you reset it, regardless of intervening OUTFILE commands that send output to a file. That is, the value of PAGESIZE is automatically saved for the default outfile.
To set PAGESIZE for a file, first make the file your current outfile by specifying its name in an OUTFILE command, then set PAGESIZE to the desired value. The new value remains in effect until you reset it or until you use an OUTFILE command to direct output to a different outfile. When you direct output to a different outfile, PAGESIZE returns to its default value of
66 for the file.