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: Gary England <gengland_at_hiwaay.net>
Date: 1997/09/25
Message-ID: <342A9E52.C33@hiwaay.net>#1/1 







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




Computers are not clairvoyant.  The best shot you have isto duplicate
the query with "COUNT(*)".
Received on Thu Sep 25 1997 - 00:00:00 CDT












Original text of this message













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