oracle学习——游标.sql

set serveroutput on;
declare
  cursor myCursor is select * from categoryinfo;
  myRow categoryinfo%rowtype;
  v_count number(8,0);
begin
--  select count(*) into v_count from categoryinfo;
  open myCursor;
 -- while v_count>0 
    loop
      fetch myCursor into myRow;
      dbms_output.put_line(myRow.categoryid||','||myRow.categoryname);
  --    v_count:=v_count-1;
      exit when myCursor%notfound;
    end loop;
  close myCursor;
end;

declare
  cursor myCursor  is select * from categoryinfo;
  type myTable is table of categoryinfo%rowtype;
  myc myTable;
begin
 -- open myCursor;
  /**
    loop
    fetch myCursor bulk collect into myc limit 3;
    for i in 1..myc.count 
      loop
        dbms_output.put_line(myc(i).categoryid||','||myc(i).categoryname);
      end loop;
     dbms_output.put_line('----');
    exit when myCursor%notfound;
    end loop;**/
    for r in myCursor loop
      dbms_output.put_line(r.categoryid||','||r.categoryname);
    end loop;
  --close myCursor;
end;

--游标参数

--隐式游标