declare 
cursor  c1(n number) is select rownum id from dual connect by rownum<=n;
begin
  for c in c1(10) loop
    dbms_output.put_line(c.id);
  end loop;
end;


declare 
cursor  c1(n number) is select rownum id from dual connect by rownum<=n;
v_n number;
begin
  open c1(10);
  LOOP 
    FETCH c1  into v_n;
    EXIT WHEN c1%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(v_n);
  END LOOP;
end;
复制