循环

一、基本循环
loop
  [#]
  exit when [结束条件];
end loop;

二、While 循环
while [循环条件=true]
loop
  [#]
end loop;

三、集合循环
[索引变量=i] := [集合变量].first;
while [索引变量] is not null
loop
  [#] 
  [索引变量] := [集合变量].next([索引变量]);
end loop;

四、整数 for 循环
for [索引变量=i] in [反向 = /"reverse "][下限=1]..[上限=10]
loop
  [#]
end loop;

五、显式游标循环
open [游标名称];
loop
  fetch [游标名称] into [游标记录变量];
  exit when [游标名称]%notfound;
  [#]
end loop;
close [游标名称];

六、隐式游标循环
for [游标名称=c] in ([Select 语句=select ])
loop
  [#]
end loop;