Re: How to get total number of rows before executing the sql /fetch

I am still quite new to Oracle but I don't think that number is known yet. Open cursor begins processing the data but has not yet processed all of it. One the other hand I was quite suprised to get a no data found on a declare cursor?

Sidhartha Sahoo <ssahoo_at_altro.com> wrote in article <34285F33.28BE43FC_at_altro.com>...
> We want to know the toal number of rows expected in a cursor fetch
> before doing actual fetch. (before executing)
>
> thanks
>
> Sidhartha
>
>
Received on Wed Sep 24 1997 - 00:00:00 CDT