Create procedure lp
is
cursor pt is select * from emp;
begin
for i in pt loop
update emp
set sal = 0 where empno = i.empno
end loop;
END;
谢谢啦!~
is
cursor pt is select * from emp;
begin
for i in pt loop
update emp
set sal = 0 where empno = i.empno
end loop;
END;
谢谢啦!~
Create or replace procedure lp
is
cursor pt is select * from emp;
begin
for i in pt loop
update emp
set sal = 0 where empno = i.empno
end loop;
END;
看你这个存储过程,写的多累,
直接用语句update emp set sal=0 就OK了嘛!