Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.orgReceived on Mon Feb 12 2007 - 17:54:45 CST