1.条件控制:
if 条件1 then
if 条件2 then
语句段1
else
语句段2
end if;
else
语句段3;
end if;
2.循环控制
for 循环变量 in 循环上届..循环下届 loop
循环处理语句段
end loop;
3.事务控制
(1)commit
(2)rollback
(3)savepoint 保存点名; rollback 保存点名;
if 条件 then
语句段;
end if;
语句段;
end if;
if 条件 then
语句段1;
else
语句段2;
end if;
语句段1;
else
语句段2;
end if;
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2.循环控制
loop
循环语句段;
if 条件语句 then
exit;
else
退出循环的处理语句段;
end if;
end loop;
循环语句段;
if 条件语句 then
exit;
else
退出循环的处理语句段;
end if;
end loop;
loop
循环语句段
exit when 退出条件
end loop
end;
循环语句段
exit when 退出条件
end loop
end;
while 循环条件 loop
循环语句段
end loop
循环语句段
end loop
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
(1)commit
(2)rollback
(3)savepoint 保存点名; rollback 保存点名;