Re: How to get total number of rows before executing the sql /fetch
From: NNOOR <Nnoor_at_cris.com>
Date: 1997/10/01
Message-ID: <60tehf$59n_at_examiner.concentric.net>#1/1
Date: 1997/10/01
Message-ID: <60tehf$59n_at_examiner.concentric.net>#1/1
[Quoted] Just a suggestion: Try "simplifying" the query (may be return only the key column, etc) and run this mock query in a stored proc. PL/SQL has an internal variable (attribute) defined called %ROWCOUNT. Use it.
What I am trying to say is that if you are stuck with doing the query to find out the count, try minimizing the damage.
Good Luck.
Nasir (nnoor_at_cris.com) Received on Wed Oct 01 1997 - 00:00:00 CEST