Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Receiving Query result...
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