plsqlus 游标的容易实例

plsqlus 游标的简单实例
Set serveroutput on;%ISOPEN : 判断游标是否打开的%FOUND游标发现数据%NOTFOUND 游标没有发现数据%ROWCOUNT 游标可以遍历的记录数量create or replace procedure cursortestisemployeename varchar2(20);employeejob varchar2(9);employeesal number(7,2);cursor cselectempisselect ename,job,salfrom scott.emp;beginopen cselectemp;loopfetch cselectempinto employeename,employeejob,employeesal;exit when cselectemp%notfound;dbms_output.put_line('employeename is '||employeename||'employeejob is '||employeejob||'employeesal is '||employeesal);end loop;close cselectemp;end;