Title: Construct and use an IF-THEN-ELSE statement.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Constructing PL/SQL Program Structures to Control Execution Flow

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.