带参数游标
declare
cursor c(v_deptno emp.deptno%type, v_job emp.job%type)
is select ename, sal from emp where deptno = v_deptno and job = v_job;
begin
for v_tmp in c(30, 'CLERK') loop
dbms_output.put_line(v_tmp.ename);
end loop;
end;
/
可更新的游标
declare
cursor c
is
select * from emp2 for update;
begin
for v_tmp in c loop
if(v_tmp.sal<2000) then
update emp2 set sal = sal * 2 where current of c;
elsif (v_tmp.sal = 5000) then
delete from emp2 where current of c;
end if;
end loop;
commit;
end;
/
注: 赋值用符号":=", 判断两个值是否相等用符号"="