17,086
社区成员
发帖
与我相关
我的任务
分享
declare
ssum number;
begin
ssum := 0;
for i in 1 .. 100 loop
ssum := ssum + i;
end loop;
dbms_output.put_line(ssum);
end;
select sum(rownum) sum101 from dual connect by rownum <=100
----------------------------------------------------------
5050
SQL> set serveroutput on
SQL> declare
2 c_sum number:=0;
3 begin
4 for i in 1..100 loop
5 c_sum:=c_sum+i;
6 end loop;
7 dbms_output.put_line(c_sum);
8 end;
9 /
5050
PL/SQL 过程已成功完成。
SQL> set serveroutput on
SQL>
SQL> declare
2 v_num number;
3 i number;
4 begin
5 i := 0 ;
6 v_num := 0;
7 loop
8 exit when i = 101;
9 v_num := i + v_num;
10 i := i + 1;
11 end loop;
12 dbms_output.put_line(v_num);
13 end;
14 /
5050
PL/SQL procedure successfully completed
SQL>
--小妹妹,不用重复发帖哦
declare
cnt number:=0;
begin
for i in 1..100 loop
cnt:=cnt+i;
end loop;
dbms_output.put_line(cnt);
end;
declare
cnt number:=0;
begin
for i in 1..100 loop
cnt:=cnt+i;
end loop;
dbms_output.put_line(cnt);
end;