oracle 游标的写法

1、简化写法

declare
  cursor cur_emp is select empno,ename,sal from emp order by empno;
begin
  for cv_emp in cur_emp
  loop
      dbms_output.put_line('empno='||cv_emp.empno||',ename='||cv_emp.ename||',sal='||cv_emp.sal);
  end loop;
end;

2、传统写法

declare
  v_empno emp.empno%type;
  v_ename emp.ename%type;
  v_sal emp.sal%type;
  cursor cur_emp is select empno,ename,sal from emp order by empno;
begin
  open cur_emp;
  loop
  fetch cur_emp into v_empno,v_ename,v_sal;
        exit when cur_emp%notfound;
        dbms_output.put_line('empno='||v_empno||',ename='||v_ename||',v_sal='||v_sal);
  end loop;
  close cur_emp;
end;