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

[Quoted] 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; Received on Wed Oct 08 1997 - 00:00:00 CEST