PAGING

The PAGING option controls the production of paged output in Oracle OLAP. When you set PAGING to YES, output from statements such as DESCRIBE, REPORT, ROW command, HEADING, SHOW, and LISTNAMES is produced in a page-oriented format. Output is produced in page-size segments with standard top and bottom margins and headings. You can use a variety of paging-related options to change the size of the page, the size of the margins, and the headings on each page.

Paging is useful primarily for making output more attractive when you plan to print output that you send to a file. However, you can also send paged output to the default outfile. Normally you would set the PAGING option in the initialization section of a report program to turn paging on for your report.

Data type

BOOLEAN

Syntax

PAGING = {YES|NO}

Arguments

YES

Produces output with page breaks, top and bottom margins, and page headings.

NO

Produces output that contains no page breaks, top and bottom margins, or page headings. Output is continuous, one line after another. (Default)

Notes

When you set PAGING 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 PAGING is automatically saved for the default outfile.

To set PAGING for a file, first make the file your current outfile by specifying its name in an OUTFILE command, then set PAGING 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, PAGING returns to its default value of NO for the file.

Oracle OLAP uses default values for page length, page headings, and top and bottom margins. You can change these values by setting the PAGESIZE, PAGEPRG, TMARGIN, and BMARGIN options. Other paging options that become meaningful when PAGING is turned on are LINENUM, LINESLEFT, and PAGENUM.

The value of PAGING for the current outfile determines whether the paging-related options will be used. You must set PAGING to YES for the current outfile in order to make the paging options take effect.

When you use the OUTFILE command to direct output to a file, all the paging-related options are set to their default values for the file. When you use the OUTFILE command with the EOF keyword to redirect output to the default outfile, the paging-related options will contain the values that they last held for the default outfile.

When you set PAGING to NO, the value of the LINENUM option continues to increment as more output lines are produced. When you set PAGING to YES, LINENUM is set to 1 and it begins counting lines on the current page.

When you set PAGING to NO, the LINESLEFT option is set to PAGESIZE, and it keeps this value until PAGING is set to YES. When you set PAGING to YES, LINESLEFT begins counting the lines left on the current page.

When you set PAGING to NO, the PAGENUM option stops counting and retains its current value. When you set PAGING to YES, PAGENUM resumes counting at the page number where it left off.

Examples

OUTFILE 'repfile.txt'
PAGING = YES
PAGESIZE = 84
TMARGIN = 6