Re: Copy a record from 1-table to another

On 14 Dec 2005 14:43:47 -0800, "JoeT" <trubisz_at_yahoo.com> wrote:

>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.

And this requires only a little cutting and pasting...

just
spool x
desc r
spool off
edit x and transform it into s
OR
Use Toad, select all columns, right click and generate an INSERT statement.
Your solution is a *disaster* in terms of performance as you are fetching record for record. You would at least need to do a BULK COLLECT and BULK INSERT,
and coding that is WAY MORE WORK than
INSERT SELECT Geeez, don't people learn to WORK anymore nowadays? It sure looks like!!

--
Sybrand Bakker, Senior Oracle DBA