Re: Copy a record from 1-table to another

Unfortunately, while this is A solution, I'm trying to avoid it. We are talking about well over 200-attributes in the table in the real system.
All I want to do is copy R (which is over 200 attributes) to S which is the same structure with 3-additional attributes, and populate the 3-attributes when I do this.

I tried types, records, varrays, etc.

Joe

Sybrand Bakker wrote:
> On 14 Dec 2005 12:54:33 -0800, "JoeT" <trubisz_at_yahoo.com> wrote:
>
> >Anyone have any suggestions?
>
>
> insert into s(col1, col2, col3, col4 ....)
> select col1, col2, col3, col4
> from r
>
> will work like a charm, and moreover: it will be a lot faster compared
> to your nonscalable solution.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Dec 14 2005 - 16:43:47 CST