|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
A group of statements that are to be executed under a condition specified by an IF command
The CASE labels for a SWITCH command.
DO and DOEND are like opening and closing parentheses; you cannot use one without the other. You can use DO and DOEND only within programs.
One or more OLAP DML statements, user-defined programs, or both.
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.
Example 11-14 DO and DOEND with the FOR Command
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 and DOEND to bracket the ROW and BITAND commands 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