SQL> set serveroutput on SQL> SQL> declare 2 v_num number; 3 begin 4 v_num:=0; 5 for i in 1..100 loop 6 v_num:=v_num+i; 7 end loop; 8 dbms_output.put_line(v_num); 9 end; 10 /
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 c_sum number:=0; begin for i in 1..100 loop c_sum:=c_sum+i; end loop; dbms_output.put_line(c_sum); end;
oracle~ 我还在用mysql 差距啊差距
-------这个行不? SQL> select sum(rn) from (select rownum rn from dual connect by rownum <= 100); SUM(RN) ---------- 5050SQL>
小妹,告诉你的老师,无须存储过程,用这个SQL就行了,SELECT SUM(ROWNUM) FROM DUAL CONNECT BY ROWNUM<101
select sum(rownum) sum100 from dual connect by rownum <101 -------------------------------------------------- sum100 5050我靠,我这里网速也特慢,是谁的问题呢?
declare 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 begin
4 v_num:=0;
5 for i in 1..100 loop
6 v_num:=v_num+i;
7 end loop;
8 dbms_output.put_line(v_num);
9 end;
10 /
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;
c_sum number:=0;
begin
for i in 1..100 loop
c_sum:=c_sum+i;
end loop;
dbms_output.put_line(c_sum);
end;
我还在用mysql
差距啊差距
-------这个行不?
SQL> select sum(rn) from (select rownum rn from dual connect by rownum <= 100); SUM(RN)
----------
5050SQL>
select sum(rownum) sum100 from dual connect by rownum <101
--------------------------------------------------
sum100
5050我靠,我这里网速也特慢,是谁的问题呢?
declare
cnt number:=0;
begin
for i in 1..100 loop
cnt:=cnt+i;
end loop;
dbms_output.put_line(cnt);
end;