Re: a row-level operator for copying?

sybrandb <sybrandb_at_gmail.com> wrote:
> On Jul 25, 3:45 pm, "Chris L." <diver..._at_uol.com.ar> wrote:
> > > insert into atest_history
> > > select * from atest
> > > where c = 1;
> >
> > > delete from atest
> > > where c = 1;
>
> One could BULK COLLECT the IDs of the affected columns in a
> collection, and BULK INSERT them into the history table and BULK
> DELETE them from the original table.
> Or one would list partition the table, and just truncate the
> partition.

Both of these look great. Thanks Chris and Sybrand!

Mark

-- 
Mark Harrison
Pixar Animation Studios