cursor-plsql

Page 1

cursor

Implicit Cursor :- %found , %notfound , %isopen , %rowcount.

%isopen always returns "false".

EX-

if sql%found then

total_row :- sql%rowcount;

end if;

explicit cursor

declare EX:-

AS

c_id number;

c_name varchar2;

cursor C is select names from sales where order_id=c_id;

opening cursor and fetching data and closing cusor

Begin

open c;

fetch c into c_name;

close c;

End;

cursor that fetches multiple rows

Begin

open c;

loop

fetch c into c_name;

exit when c%notfound;

<statements>;

end loop;

close c;

End;