一:条件控制语句
(1):if条件语句:
if search_condition then statement_list
[elseif search_condition then statement_list].....
[else search_condition]
endif
(2):case条件语句
case case_value
when when_value then statement_list
[when when_value then statement_list]...
[else statement_list]
end case;
二: 循环控制语句
(1):loop语句
[begin_labe:]loop
statement_list
end loop [end_lable]
begin_lable 和end_lable参数分别表示循环开始和循环结束的标志。若想提前结束可以用leave loop;
(2):while语句
[begin_label:]while search_condition do
statement_list
end while[end_label]
(3):repeat语句
[begin_label:]repeat search_codition do
statement_list
end repeat [end_lable]