Re: data loading question

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Tue, 11 Aug 1998 17:06:51 GMT
Message-ID: <01bdc54a$777d6400$049a0580@mcb>

Create another table with your new column and some other key column that you can join to your existing table on, load the data into that table, then do an update with a subquery that joins the two tables. Finally, drop the other table that you had loaded.

(SQL*Loader is really just for straightforward inserts, not updates.) --
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Iancrozier <iancrozier_at_aol.com> wrote in article <1998081113295500.JAA00722_at_ladder01.news.aol.com>...
> I have a table which had a new column added recently.
> I now have data to load into this new column.
> Is there any way that I can just add data to this column?
> sqlload offers four methods:
> INSERT,REPLACE,APPEND AND TRUNCATE
>
> They only work on complete rows. Is there any way just to add data to
> ceratin columns? Thanks in advance.
>
Received on Tue Aug 11 1998 - 12:06:51 CDT