Oracle cursors kullanımı
14 January 2008 – 20:30Oracle’da cursor kullanımı
declare
vRC1 SYS_REFCURSOR;
vTemp acc_def%rowtype;
begin
OPEN vRC1 FOR SELECT * from acc_def;
loop
fetch vRC1 into vTemp;
exit when vRC1%notfound;
dbms_output.put_line(':'||vTemp.id_no || '-'||vTemp.description);
end loop;
end;
