Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The TMARGIN option defines the number of blank lines for the top margin of output pages, above the running page heading. TMARGIN is meaningful only when PAGING is set to YES
and only for output from statements such as REPORT and DESCRIBE. The TMARGIN option is usually set in the initialization section of report programs.
Data type
INTEGER
Syntax
TMARGIN = n
Arguments
An integer expression that specifies the number of lines that you want to set aside for the top margin in a report. The default is 2
.
Notes
The top margin lines are produced before the program that is defined by PAGEPRG, if any, is run.
When you set TMARGIN 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 TMARGIN is automatically saved for the default outfile.
To set TMARGIN for a file, first make the file your current outfile by specifying its name in an OUTFILE command, then set TMARGIN 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, TMARGIN returns to its default value of 2 for the file.
Examples