WHILE <condition> LOOP <sequence_of_statements>; [EXIT [WHEN <condition>]]; END LOOP;
while condition loop --you code end loop;
什么循环都有了., create or replace procedure EX_LOOP(pLoopNumber number) is i number; begin dbms_output.put_line('The time of loop: ' || pLoopNumber);
dbms_output.put_line('[loop... end loop] starting.'); i:=1; loop dbms_output.put_line(' Current:' || i); i:=i+1; exit when i>pLoopNumber; end loop;
dbms_output.put_line('[while loop... end loop] starting.'); i:=1; while i<=pLoopNumber loop dbms_output.put_line(' Current:' || i); i:=i+1; end loop; dbms_output.put_line('[for loop... end loop] starting.'); for i in 1..pLoopNumber loop dbms_output.put_line(' Current:' || i); end loop; insert into test(a,b) values('Test2',1); end ;
<sequence_of_statements>;
[EXIT [WHEN <condition>]];
END LOOP;
loop
--you code
end loop;
create or replace procedure EX_LOOP(pLoopNumber number) is
i number;
begin
dbms_output.put_line('The time of loop: ' || pLoopNumber);
dbms_output.put_line('[loop... end loop] starting.');
i:=1;
loop
dbms_output.put_line(' Current:' || i);
i:=i+1;
exit when i>pLoopNumber;
end loop;
dbms_output.put_line('[while loop... end loop] starting.');
i:=1;
while i<=pLoopNumber loop
dbms_output.put_line(' Current:' || i);
i:=i+1;
end loop; dbms_output.put_line('[for loop... end loop] starting.');
for i in 1..pLoopNumber loop
dbms_output.put_line(' Current:' || i);
end loop;
insert into test(a,b) values('Test2',1);
end ;