Oracle学习笔记6

一．游标
1）--do while循环
Declare
Cursor c is select * from emp;
V_emp c%rowtype;
              Begin
                     Open c;
                     loop
                            Fetch c into v_emp;
                            Exit when (c%notfound);
                            Dbms_output.put_line(v_emp.ename);
                     End loop;
                     Close c;
              End;
2）--while 循环
Declare
Cursor c is select * from emp;
V_emp c%rowtype;
              Begin
                     Open c;
                     Fetch c into v_emp;
                     While (c%found) loop
            &