SQL Language Guide : 8. SQL Statements : IF - THEN - ELSE : If-Then-Else Example
 
Share this page                  
If-Then-Else Example
The following IF statement performs a delete or an insert and checks to make sure the statement succeeded:
IF (id > 0) AND (id <= maxid) THEN
       DELETE FROM emp WHERE id = :id;
       IF iierrornumber > 0 THEN
              message 'Error deleting specified row';
              return 1;
       ELSEIF iirowcount = 0 THEN
              message 'Specified row does not exist';
              return 2;
       ENDIF;
ELSEIF (id < maxid) THEN
       INSERT INTO emp VALUES (:name, :id, :status);
       IF iierrornumber > 0 THEN
              message 'Error inserting specified row';
              return 3;
       ENDIF;
ELSE
message 'Invalid row specification';
return 4;
ENDIF;