游标

带变量的游标

declare
n number:=1.5;
CURSOR cur2 IS select ename, sal, sal*n newsal from emp where deptno=20;
c cur2%rowtype;
begin
open cur2;
loop
fetch cur2 into c;
exit when cur2%notfound;
DBMS_OUTPUT.PUT_LINE(' name:'||c.ename||' oldsal:'||c.sal||' newsal:'||c.newsal);
end loop;
close cur2;
end;

带参数的游标

declare
CURSOR cur3(dno number) IS select ename, sal from emp where deptno=dno;
c cur3%rowtype;
begin
open cur3(20);
loop
fetch cur3 into c;
exit when cur3%notfound;
DBMS_OUTPUT.PUT_LINE(' name:'||c.ename||' sal:'||c.sal);
end loop;
close cur3;
end;

带参数的游标(for loop)

declare
CURSOR cur3(dno number) IS select ename, sal from emp where deptno=dno;
begin
for c in cur3(20)
loop
DBMS_OUTPUT.PUT_LINE(' name:'||c.ename||' sal:'||c.sal);
end loop;
end;