Re: number of rows in cursor?

Am Fri, 10 Dec 2004 09:45:50 +0100 schrieb eudorica <snjezana.katusic_at_htnet.hr>:

> Is there way to count a number of rows in opened cursor before fetching
> it
> (%rowcount works only after fetching)? I need to know the number of rows
> before enter loop. Thanks.
>
>

You may count the rows explicitly before entering the loop.

if the cursor statement is: select <projection-clause>

                                from ....

you may count with:         select count(rowid) into <counter_var>
                                from ....

where <counter_var> is some local variable into which you may store the number of rows the cursor will retrieve.

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)