if
条件
then
语句段;
end if ;
语句段;
end if ;
if
条件
then
语句段1;
else
语句段2;
end if ;
语句段1;
else
语句段2;
end if ;
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![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
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
(1)commit
(2)rollback
(3)savepoint 保存点名; rollback 保存点名;