--小妹妹,不用重复发帖哦declare cnt number:=0; begin for i in 1..100 loop cnt:=cnt+i; end loop; dbms_output.put_line(cnt); end;
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>
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>
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 / 5050PL/SQL 过程已成功完成。
select sum(rownum) sum101 from dual connect by rownum <=100 ---------------------------------------------------------- 5050拜膜楼主,您太有分了~
declare cnt number:=0; begin for i in 1..100 loop cnt:=cnt+i; end loop; dbms_output.put_line(cnt); end;
declare ssum number; begin ssum := 0; for i in 1 .. 100 loop ssum := ssum + i; end loop; dbms_output.put_line(ssum); end;
cnt number:=0;
begin
for i in 1..100 loop
cnt:=cnt+i;
end loop;
dbms_output.put_line(cnt);
end;
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>
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>
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 /
5050PL/SQL 过程已成功完成。
select sum(rownum) sum101 from dual connect by rownum <=100
----------------------------------------------------------
5050拜膜楼主,您太有分了~
declare
cnt number:=0;
begin
for i in 1..100 loop
cnt:=cnt+i;
end loop;
dbms_output.put_line(cnt);
end;
declare
ssum number;
begin
ssum := 0;
for i in 1 .. 100 loop
ssum := ssum + i;
end loop;
dbms_output.put_line(ssum);
end;
-- 不错:一个 connect by 搞定......