oracle中pl/sql编程 编写1+2+3+。。。。+100的和？？

[yadegougou]

oracle中pl/sql编程 编写1+2+3+。。。。+100的和？？
小妹要考试了 这个不会啊？哪个大侠会啊？？？

[njlywy]

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;

[minitoy]

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>

[minitoy]

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> 

[心中的彩虹]

[Quote=引用楼主 yadegougou 的回复:]
oracle中pl/sql编程 编写1+2+3+。。。。+100的和？？
小妹要考试了 这个不会啊？哪个大侠会啊？？？
[/Quote]

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 过程已成功完成。

[终端用户]

select sum(rownum) sum101 from dual connect by rownum <=100
----------------------------------------------------------
5050

拜膜楼主，您太有分了～

[Dream_1986]

declare
  ssum number;
begin
  ssum := 0;
  for i in 1 .. 100 loop
    ssum := ssum + i;
  end loop;
  dbms_output.put_line(ssum);
end;

[luoyoumou]

[Quote=引用 5 楼 lxyzxq2008 的回复:]

SQL code

select sum(rownum) sum101 from dual connect by rownum <=100
----------------------------------------------------------
5050


拜膜楼主，您太有分了～
[/Quote]

-- 不错：一个 connect by 搞定......