declare cursor s2 is select * from emp where (ename like'A%' or ename like 'S%');
v_res emp%rowtype;
begin
open s2;
fetch s2 into v_res;
loop
exit when s2% notfound;
update emp set sal= sal*0.1+sal where v_res.ename=ename;
fetch s2 into v_res;
end loop;
close s2;
end;
v_res emp%rowtype;
begin
open s2;
fetch s2 into v_res;
loop
exit when s2% notfound;
update emp set sal= sal*0.1+sal where v_res.ename=ename;
fetch s2 into v_res;
end loop;
close s2;
end;
版权声明:本文为weixin_42121296原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。