oracle else if
IF condition1 THEN {...statements to execute when condition1 is TRUE...} ELSIF condition2 THEN {...statements to execute when condition1 is FALSE and condition2 is TRUE...} ELSE {...statements to execute when both condition1 and condition2 are FALSE...} END IF;