Construction and use an IF-THEN-ELSE statement should include
- describing the function of THEN in a program that considers alternative courses of action
- describing the function of ELSE in a program that considers alternative courses of action
- describing a program that will have alternative courses of action and multiple tests on a condition or conditions
- writing a program in PL/SQL that contains alternative courses of action within a block, based on a condition, adds additional statements based on additional conditions, and has a last alternative
- executing the PL/SQL program that contains alternative courses of action and multiple conditions.