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;
