Re: Problem with FETCH/INTO

From: Dan Blum <>
Date: Tue, 5 Aug 2008 17:11:35 +0000 (UTC)
Message-ID: <g7a1k7$38h$>

Laurenz Albe <> wrote:
> Dan Blum <> wrote:
> >>> You can't fetch into a table. What you want there is a record collection.
> >>> Unless of course you really want to copy records from one table to
> >>> another, in which case you want to use INSERT INTO tblName2 SELECT FROM
> >>> tblName1 ...
> >
> >> Yeah. That's probably what I want except that it is a very big table,
> >> and I want to do it a few records at a time. Can I use the LIMIT
> >> modifier on an INSET INTO/ SELECT statement like that?
> >
> > Why do you want to do it a few records at a time?

> Just guessing, but maybe the 10^8 or so records that the query yields
> would not fit into memory?

That is irrelevant if you are simply inserting the rows into another table - there is no need for Oracle to hold all the rows in memory at once, and so it doesn't.

Dan Blum					
"I wouldn't have believed it myself if I hadn't just made it up."
Received on Tue Aug 05 2008 - 12:11:35 CDT

Original text of this message