Oracle 中的修改数据?用游标!!!
--------------用游标修改工资--------
declare
cursor mysor is select * from emp ;
mysal emp.sal%type;
begin
for i into mysor
loop
if i.deptno = 10 then
mysal := (mysal+500)*2;
update emp set sal=mysal where current of mysor;
elsif i.deptno = 20 then
mysal := mysal+500;
update emp set sal=mysal where current of mysor;
else
mysal := mysal - 500;
update emp set sal=mysal where current of mysor;
end if ;
end loop;
end;
上面代码可以成功运行但是为什么里面要用 mysal := mysal-500 并且把mysal的值赋给sal ;
为什么直接写sal=sal-500;运行报错:
有谁了解Oracle中游标,望解答疑问》???