-- while-loop循环 (未完成)
create or replace procedure testwhileloop is
v_count number := 0;
begin
while v_count <10 loop
v_count := v_count + 2;
dbms_output.put_line('v_count:'||v_count);
end loop;
end;
执行成功了,在调用过程中也成功了,就是没输出 v_count的值,请大师们帮帮忙,帮我解决下!!!
create or replace procedure testwhileloop is
v_count number := 0;
begin
while v_count <10 loop
v_count := v_count + 2;
dbms_output.put_line('v_count:'||v_count);
end loop;
end;
执行成功了,在调用过程中也成功了,就是没输出 v_count的值,请大师们帮帮忙,帮我解决下!!!
v_count number := 0;
begin
while v_count < 10 loop
v_count := v_count + 2;
dbms_output.put_line('v_count:' || v_count);
end loop;
end;
/SQL> set serveroutput on; --要先执行这句,打开输出开关,这样才能看到输出的结果
SQL> exec testwhileloop;
v_count:2
v_count:4
v_count:6
v_count:8
v_count:10
PL/SQL procedure successfully completed
SQL>
设置显示输出;
v_count number := 0;
begin
while v_count < 10 loop
v_count := v_count + 2;
pi_v_count := pi_v_count||'v_count:'||v_count;
dbms_output.put_line('v_count:' || v_count);
end loop;
end;
这样用选中testwhileloop -->test 可以看到输出值,而且点击DBMS Output 菜单选项可以看到值