Question

请教各位这个存储过程哪出语法不对，为什么会有编译错误？

create or replace procedure p is cursor c is select * from emp2 for update;begin for v_temp in c loop if(v_temp.deptno = 20) then update emp2 set sal * 2 where current of c; end if; end loop;end;

Answer 1

那个UPDATE语句有错误，缺少代码，错误提示：missing equal sign，应该是sal=sal*2才是，
update emp2 set sal=sal * 2 where current of c;