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: Receiving Query result...

Re: Receiving Query result...

From: Ed Bruce <Ed.Bruce_at_ha.hac.com>
Date: Mon, 04 May 1998 15:31:08 -0500
Message-ID: <354E258C.3E22D1@ha.hac.com>


Hans Duijn wrote:
>
> ...its just that I'm using a front end tool that lets users download a
> 'recordset' on demand (at least, thats what I want). Normally he >resultset
> is 'downloaded' in arrays. Downloading 100.000 rows to these arrays at >once
> takes a lot of time so I want it to do just in parts. Perhaps there's
> another way?

If I understand your question to be can I make SQL divide my result set into 'groups of data' and get those groups one at a time and I suppose you want to do this with one SQL statement, then I would say no. This is more dependant on what your front end tool supports.

Most tools I have worked with have some mechanism to buffer rows and request more rows as the user exhausts the current buffer. This is where I would look for the answer.

Ed Bruce
Raytheon Systems Co. Received on Mon May 04 1998 - 15:31:08 CDT

Original text of this message

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