loop循环:
declare
v1 int:=1;
v2 int:=0;
begin
loop
v2:=v2+v1;
dbms_output.put(v1||'+');
v1:=v1+1;
exit when v1=10;
end loop;
dbms_output.put_line('10='||(v1+v2));
end;
while循环:
declare
v1 int:=1;
v2 int:=0;
begin
while v1<10 loop
v2:=v2+v1;
dbms_output.put(v1||'+');
v1:=v1+1;
end loop;
dbms_output.put_line('10='||(v1+v2));
end;
for循环:
declare
v_sum int:=0;
begin
for i in 1..9 loop
v_sum:=v_sum+i;
dbms_output.put(i||'+');
end loop;
dbms_output.put_line('10='||(v_sum+10));
end;