How to check last row of a cursor
518838Jun 11 2007 — edited Jun 11 2007Hi,
I'm having a cursor for loop like below:
for rec_cur in(select a,b,c from abc) loop
...
...
end loop;
If the above loop, I wanna check if the record I'm processing on, is last record or not (or simply I want to know the total rows fetched by cursor).
for rec_cur in(select a,b,c from abc) loop
...
if (on last record) then
do 'x';
else
do 'y';
end if;
end loop;
Please help me to achieve the required action.
Thanks
Deepak