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

The most obvious thing would be to do a "select count(*) into variable_name" using your cursor's sql stmt. Yes, this is a duplicate execution of the same sql.

Hope this helps.

-Ratan
Sidhartha Sahoo wrote:
>
> 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