Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The BLANK command sends one or more blank lines to the current outfile. BLANK is normally used only in programs. For example, in a report program, BLANK is commonly used to insert blank lines that separate headings from data or that separate groups of data from one another.
Syntax
BLANK [n]
Arguments
An INTEGER expression with a value of 0
(zero) or higher, that specifies how many blank lines should be inserted. When you omit n, Oracle OLAP inserts one blank line. NA
produces an error.
Examples
Example 8-29 Inserting Blank Lines
This example inserts two blank lines between the title of a report and the column headings. The following lines are from a report program.
LSIZE = 50 HEADING WIDTH LSIZE CENTER 'Quarterly Sales Report' BLANK 2 ROW WIDTH 20 'Unit Sales' ACROSS month - 'Jan96' TO 'Mar96': month
The program produces the following output.
Quarterly Sales Report Unit Sales Jan96 Feb96 Mar96