declare
i int;
k int;
begin
i:=1;
k:=0;
while i<=100 loop
k:=k+i;
i:=i+1;
end loop;
dbms_output.put_line(k);
end;
ä¸è¾¹æ¯ç¨while循ç¯ï¼ä¸è¾¹è¿ä¸ªç¨for循ç¯
declare
k int;
begin
k:=0;
for i in 1..100 loop
k:=k+i;
end loop;
dbms_output.put_line(k);
end;
追é®ç¨éå½ç®æ³å大å¥
ä½ è¿ä¸ªæ¯å¾ªç¯ä¸æ¯éå½
追çdeclare
i int;
j int;
begin
i:=100;
with t as
(select sum(rownum) rn from dual connect by rownum<=i)
select rn into j from t;
dbms_output.put_line(j);
end;
è¿æ ·ï¼