|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
A group of statements that are to be executed under a condition specified by an IF command
A group of statements in a repeating loop introduced by FOR or WHILE
The CASE labels for a SWITCH command.
You can put one DO statement inside another to nest groups of statements. You can nest as many groups as you want, if each DO statement has a corresponding DOEND to indicate the end of its statement group.
One or more OLAP DML statements, user-defined programs, or both.
Within a FOR loop of a program, when a DO/DOEND phrase follows TEMPSTAT, status is restored when the DOEND, BREAK, or GOTO is encountered.
Suppose you want to use the ROW command to produce a report that shows the unit sales of tents for each of 2 months. Use DO ... DOEND to bracket the ROW and BLANK statements you want to execute repeatedly for each value of the
month dimension. You might write the following program.
LIMIT month TO 'Jan96' to 'Feb96' ROW district ROW UNDER '-' VALONLY name.product FOR month DO ROW INDENT 5 month WIDTH 6 UNITS BLANK DOEND
The program produces the following output.
BOSTON 3-Person Tents -------------- Jan96 307 Feb96 209