--pl/sql带参数的游标案列
declare
cursor c(v_deptno dept.deptno%type,v_job emp.job%type) is
select ename,sal from emp where deptno=v_deptno and job = v_job;
begin
for v_emp in c(30,'SALESMAN') loop--给游标传递参数
dbms_output.put_line(v_emp.ename);
end loop;
end;
--pl/sql可更新的游标案列
declare
cursor c is select * from emp2 for update;
begin
for v_emp in c loop
if (v_emp.sal < 2000) then
update emp2 set sal = sal*2 where current of c;
elsif (v_emp.sal = 3000) then
delete from emp2 where current of c;
end if;
end loop;
commit;--事务提交
end;
pl/sql带参数的游标和可更新的游标案列
最新推荐文章于 2022-12-05 18:29:58 发布