数据库流程控制

if

IF search_condition THEN statement_list [ ELSEIF search_condition THEN statement_list] ...

[ ELSE statement_list] END IF

case:

CASE case_value WHEN when_value THEN statement_list [ WHEN when_value THEN statement_list ] [ ELSE statement_list] END CASE

LOOP:

[begin_label:] LOOP

statement_list

END LOOP [end_label]

LEAVE:(跳出循环)

LEAVE label

ITERATE:

ITERATE label

REPEAT:

[begin_label:] REPEAT statement_list; UNTIL search_condition END REPEAT [end_label]

WHILE:

[begin_label:] WHILE search_condition DO Statement_list END WHILE [end_label]

实战训练: