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: Dean Dashwood <dd_at_langley.softwright.co.uk>
Date: 1997/09/24
Message-ID: <875110364.10423@dejanews.com>#1/1

Try doing a SELECT COUNT(*) ...........

If it's possible that someone could insert/delete between your COUNT(*) and the cursor FETCH, simply lock the relevant tables before the COUNT(*), and do a ROLLBACK immediately after.

Dean


In article <34285F33.28BE43FC_at_altro.com>,   ssahoo_at_altro.com wrote:
>
> We want to know the toal number of rows expected in a cursor fetch
> before doing actual fetch. (before executing)
>
> thanks
>
> Sidhartha

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Wed Sep 24 1997 - 00:00:00 CDT

Original text of this message

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