|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
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.
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.
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