17,377
社区成员
发帖
与我相关
我的任务
分享
declare
cursor s is select avalue from test2;
number a;
begin
open s;
fetch s into a;
while a<>:new.avalue and a %found loop
insert into test2(name,avalue) values('awea',:new.avalue);
fetch s into a;
end loop;
close s;
END;