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
            &