Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-+--------+--IF--search-condition--THEN----------------------->
   '-label:-'
 
   .-----------------------------.
   V                             |
>----SQL-procedure-statement-- ;-+------------------------------>
 
   .---------------------------------------------------------------------.
   V                                                                     |
>----+-----------------------------------------------------------------+-+-->
     |                                 .-----------------------------. |
     |                                 V                             | |
     '-ELSEIF--search-condition--THEN----SQL-procedure-statement-- ;-+-'
 
>--+---------------------------------------+--END IF-----------><
   |       .-----------------------------. |
   |       V                             | |
   '-ELSE----SQL-procedure-statement-- ;-+-'