|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
The BLANK command sends one or more blank lines to the current outfile. BLANK is typically used only in OLAP DML 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.
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.
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