Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-+--------+--CASE--+-simple-when-clause---+------------------->
   '-label:-'        '-searched-when-clause-'
 
>--+-------------+--END CASE-----------------------------------><
   '-else-clause-'
 
simple-when-clause:
 
|--expression--------------------------------------------------->
 
   .---------------------------------------------------------.
   |                         .-----------------------------. |
   V                         V                             | |
>----WHEN--expression--THEN----SQL-procedure-statement-- ;-+-+--|
 
searched-when-clause:
 
   .---------------------------------------------------------------.
   |                               .-----------------------------. |
   V                               V                             | |
|----WHEN--search-condition--THEN----SQL-procedure-statement-- ;-+-+--|
 
else-clause:
 
         .-----------------------------.
         V                             |
|--ELSE----SQL-procedure-statement-- ;-+------------------------|