Re: How to get total number of rows before executing the sql /fetch
From: Ratan <ratan_at_sprintmail.com>
Date: 1997/09/24
Message-ID: <3429BD31.1F72_at_sprintmail.com>#1/1
Date: 1997/09/24
Message-ID: <3429BD31.1F72_at_sprintmail.com>#1/1
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 CEST