pl/sql for循环的语法结构如下:
for loop_control_variable in[Reverse] lower uper LOOP
pl/sql语句
end loop;
例子:
- declare
- sun_num number:=0;
- begin
- for i in 1..100 loop
- sun_num:=sun_num+i;
- end loop;
- dbms_output.put_line(sun_num);
- end;
当使用reverse关键字时,循环控制变量将自动减1,并强制循环控制变量的值从上限到下限值。例如:
- begin
- for i in reverse 1..20 loop
- if mod(i,3)=0 then
- dbms_output.put_line(i);
- end if;
- end loop;
- end;