Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting array of rows from PL/SQL
You can also use "where rowcount < x" to limit query to return x-1 rows. This works in sqlplus anyway.
>> Is there a way to get an array of rows back from from a PL/SQL procedure
?
>> Specifically, what I am interested in is getting a limited fixed number
of
>> rows (in batches) at a time from the database and passing it back to the
>> client for display.
Received on Sun Jun 21 1998 - 00:00:00 CDT