How to Write IF Condition in SQL Stored Procedure Correctly

I am just in very good mood in the morning having strong ginger tea. Just I got an excellent idea on Stored procedure with SQL.

The exact point that I need to say is difference in coding of if condition for both COBOL and SQL procedure.

In COBOL, you write IF condition like below.

IF EXPRESSION 
  DO THIS
ELSE
   DO THIS
END-IF

In SQL procedure

Connect ap/ap;
Set serveroutput on;
Declare
   Variable declaration...
BEGIN
   IF EXPRESSION  THEN
          DO THIS
   ELSEIF  Expression THEN
        DO THIS
   ELSE
       DO THIS
   END IF;
END;
/

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.