SQL> declare a number;
2 begin
3 a:=0;
4 for i in 1..50 loop
5 if mod(i,2)=1 then
6 a:=a+1;
7 end if;
8 end loop;
9 dbms_output.put_line('a='||a);
10 end;
11 /PL/SQL procedure successfully completed
2 begin
3 a:=0;
4 for i in 1..50 loop
5 if mod(i,2)=1 then
6 a:=a+1;
7 end if;
8 end loop;
9 dbms_output.put_line('a='||a);
10 end;
11 /PL/SQL procedure successfully completed
这一句就会打印结果出来啦
SQL> declare a number;
2 begin
3 a:=0;
4 for i in 1..50 loop
5 if mod(i,2)=1 then
6 a:=a+1;
7 end if;
8 end loop;
9 dbms_output.put_line('a='||a);
10 end;
11 /
a=25PL/SQL 过程已成功完成。