一、不带参存储 用如下一个存储做例子： 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 testwhileloop; 执行如下命令
一、不带参存储
用如下一个存储做例子：
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 testwhileloop;
执行如下命令：
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> drop procedure testwhileloop;
Procedure dropped
SQL>
其中：
exec testwhileloop; 命令用于执行存储