Re: Populating new fields in a table?

Shayne Judkins <sjudkins_at_trendar.com> wrote:
>Could someone tell me an "easy" way (using SQL Loader or something else)
>to populate JUST THE NEW FIELDS I have added to an Oracle table? (I
>suppose I could write an app to do it, but there must be an "easy" way.)
>If you have any ideas please send EMAIL! THANKS!
>
>--
>Shayne Judkins Special Projects Manager shayne_at_trendar.com
>Trendar voice (615) 367-1000
>Nashville, Tn 37217 My opinions are my own fax (615) 367-1946

 Hi, You can't use an INSERT command to populate only the new fields,

1. Create Intermediate tables that looks the same as new tables.
2. Load all the rows into the Intermediate tables using SQL*LOADER.
3. Using an UPDATE command update the rows of the old table for only those columns that you want to insert data to.

 Hope this helps.

 Vijay Kumar Banda Received on Wed Aug 28 1996 - 00:00:00 CEST