Re: Update one table's data from another table (but skip identical records)

gordon_at_panix.com wrote:
> I'm looking for a way to update data in one table with data from
> another table.
>
> More specifically, if there are any records in the two tables which
> have matching primary keys but differing data in at least one other
> column, I need to update the values in the old table from the new
> table.
>
> I can't just do a blanket update of every record, because that would
> result in a lot of unneccesary updates -- I only want to update
> records which actually have different data.
>
> I tried an UPDATE FROM statement, but Oracle doesn't support that.
>
> I tried a MERGE INTO statement, but Oracle 9i requires action to be
> taken both when the records match *and* when they don't. Bah!
>
> Any suggestions?

And a correlated update won't work? Why? http://www.psoug.org
click on Morgan's Library
click on UPDATE

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org