create or replace procedure p
is
cursor c is select * from score for update;
begin
for sc in c loop
if(sc.score<90) then
update score set score.score=score.score+10 where current of c ;
else
update score set score.score=score.score+5 where current of c ;
end if;
end loop;
commit;
end;红色部分是什么意思
创建存储过程时没有报错
执行时报sql语句错误 请高手指点
is
cursor c is select * from score for update;
begin
for sc in c loop
if(sc.score<90) then
update score set score.score=score.score+10 where current of c ;
else
update score set score.score=score.score+5 where current of c ;
end if;
end loop;
commit;
end;红色部分是什么意思
创建存储过程时没有报错
执行时报sql语句错误 请高手指点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货