declare
he emp%rowtype;cursor mycursor(pid integer)isselect*from emp where empno = pid forupdate;beginopen mycursor(7369);while(true)loopfetch mycursor into he;exitwhen mycursor%notfound;update emp set sal =1111wherecurrentof mycursor;endloop;end;
1.3 使用游标删除指定行数据
declare
he emp%rowtype;cursor mycursor(pid integer)isselect*from emp where empno = pid forupdate;beginopen mycursor(7369);while(true)loopfetch mycursor into he;exitwhen mycursor%notfound;deletefrom emp wherecurrentof mycursor;endloop;end;
使用游标修改数据定义一个游标,游标名称为 mycursor更新scott用户中emp表中empno为7369的销售额-- Created on 2015/11/30 by ZHANW declare he emp%rowtype; cursor mycursor(pid integer) is select * from emp where empno = pid for update;......