17,082
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure p_test is
n number;
begin
select count(*) into n from nodecal;
while n>0 loop
null;--你的语句
end loop;
end;
create or replace p_test
n number;
begin
select count(*) into n from nodecal;
while n>0 loop
...............
end loop;
declare
n number;
loop
BEGIN
select count(*) into n from nodecal;
while n>0 loop
...............执行代码片段
select count(*) into n from nodecal;
end loop;
END;
declare
n number;
BEGIN
loop
select count(*) into n from nodecal;
EXIT WHEN n<=0;--每次获取到的N判定如果小于等于0,则跳出循环
.....代码片段部分
end loop;
END;
declare
v_num number;
begin
select count(*) into v_num from nodecal;
while v_num>0 loop
.....
end loop;
end;