|Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number
B10339-02 The IF...THEN...ELSE command executes one or more
commands in a program when a specified condition is met.
Optionally, it also executes an alternative command or group of
commands when the condition is not met. You can use IF only
within programs. You can also use IF as a conditional operator
in an expression. See "IF as a Conditional Operator". Any valid
Boolean expression that returns either Oracle OLAP executes the
statement1 argument when the Boolean expression is TRUE. The
statement1 must be on the same line as THEN. Oracle OLAP
executes the statement2 argument when the Boolean expression is
FALSE. The statement2 must be on the same line as ELSE. When you
omit the ELSE phrase, execution continues with the statement
after the whole IF...THEN... command in the program. You can use
the IF command for conditional execution of two or more
statements by following the THEN or ELSE (or both) keywords with
a DO ... DOEND sequence. See Example