Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get total number of rows before executing the sql /fetch

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@examiner.concentric.net>#1/1

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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US