oracle学习——游标.sql

llxbomlqdx

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;
--游标参数
--隐式游标