Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Advice For Efficient Update
Write a sql statement to do the update.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "daecc" <daecc96_at_yahoo.com> wrote in message news:e6981358.0301201735.544ac258_at_posting.google.com...Received on Mon Jan 20 2003 - 20:06:30 CST
> I have a table with 3 million records. The field "group" starts out
> null and I need to update it based on the combination of 7 other large
> text fields (I used 3 small fields for illustration purposes).
>
> rec_num field1 field2 field3 group
> ------- ------ ------ ------ -----
> 1 AA JJ XX 1
> 2 AA JJ XX 1
> 3 BB JJ XX 2
> 4 CC JJ XX 3
> 5 AA JJ XX 1
> 6 CC KK ZZ 4
> 7 CC KK ZZ 4
>
> The data is already loaded in the table and I must do an update. What
> would be the most time efficient way to accomplish this?
>
> Thanks!