Re: Counter rows in cursor using for loop.

cur%ROWCOUNT gives you the number of rows of cursor cur.

--
Regards

Michel

<screwbai_at_my-deja.com> a écrit dans le message : 7tc961$f0n$1_at_nnrp1.deja.com...
>
>
> 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:46:05 CDT