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

This will help only if it is within the same transaction as the query for which you are counting the rows which will be returned.

Robert Simard wrote:

> On 1 Oct 1997 12:09:19 GMT, Nnoor_at_cris.com (NNOOR) wrote:
>
> Try this select statement in your trigger or procedure.
> declare
> rec_count number;
> begin
> Select count(*)
> into rec_count
> from your_table
> where your_criteria;
> end;

--
Raghunath Sapuram     raghu_at_tkg.com
The Kernel Group, Inc.   (512)433-3358