正文
plsql 的三种循环
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
set serveroutput on declare
pnum number :=1 ; begin while pnum<=10 loop
dbms_output.put_line(pnum);
pnum :=pnum+1; end loop; end;
/ set serveroutput on declare
pnum number :=1 ; begin
loop
exit when pnum>10;
dbms_output.put_line(pnum);
pnum :=pnum+1;
end loop; end;
/ set serveroutput on declare
pnum number :=1 ; begin
for pnum in 1..10 loop
dbms_output.put_line(pnum); end loop; end;
/