Oracle cursor 游标

带参数游标

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;
/

注: 赋值用符号":=", 判断两个值是否相等用符号"="