Counter rows in cursor using for loop.

I want count the number of rows that a cursor contain. Basically I want to do something with the last row in the cursor.

This is what I want to do:
for rec in cur
LOOP
if counter<last
then
.......

else
.......

end if;
counter :=counter + 1;
END LOOP; I guess there is no other way to find the value of last than to introduce a second cursor for loop.

This is how I want to get to the value of last.

last :=0;
for rec in cur
LOOP
last := last + 1;
END LOOP; I am fairly happy with this solution. But would be curious if there is one that would be more elegant.

Thanks !!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 02:26:00 CDT