Re: number of rows in cursor?

Am Fri, 10 Dec 2004 13:11:32 GMT schrieb Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>:

>
> "Frank Piron" <empty_at_zero.nil> wrote in message
> news:opsisl5wh3m0et4w_at_news.online.de...
>> 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)
> Except the number could change from count to the fetch of the data.

Sure. But this is inevitable.

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)