Here’s an NULL Values in Assignment Statements

• Until a value is assigned to a variable, the variable’s value is NULL

• Performing an arithmetic value on a NULL value always results in a NULL value

• Advice: Always initialize variable values

PL/SQL Selection Structures

• IF/END IF:

IF condition THEN

program statements

END IF;

• IF/ELSE/END IF:

IF condition THEN

program statements

ELSE

alternate program statements

END IF;