Blogging is useful
August 24th, 2004
I just got use out of my blog! Somebody asked me how to chunk results in Oracle, and I remembered vaguely that I had done that before. A nice Google query returned me this entry. The "external memory" part of the subtitle of this blog is not an accident!
Update: laughed too soon (again). That link didn't provide any information on chunking in Oracle, only on other databases. This one seems to come closer to the truth. Still investigating, though.
April 21st, 2008 at 10:17 PM Ask MarcS! If he doesn't tell you the solution, there is none (based on Oracle SQL). BTW: we need this feature in the WOW application. So if you take a look in the source of the DAO, you'll find the query applied there.
April 21st, 2008 at 10:17 PM I posted some sample code for this a while back, building on what Bob Lee did. Here is the permalink: http://jroller.com/page/theymightbe/20031021