number of rows in cursor?

#11

In article <8ghud.637251$mD.2711@attbi_s02>, kennedy-
downwithspammersfamily (AT) attbi (DOT) net says...

Quote:

"Frank Piron" <empty (AT) zero (DOT) nil> wrote in message
news

psisl5wh3m0et4w (AT) news (DOT) online.de...
Am Fri, 10 Dec 2004 09:45:50 +0100 schrieb eudorica
snjezana.katusic (AT) htnet (DOT) 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.
Jim

You could surround the whole thing with "SET TRANSACTION READ ONLY" and

"COMMIT". Results should then be the same regardless of other sessions.

-- Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

number of rows in cursor?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: number of rows in cursor? - 12-13-2004 , 03:26 AM