Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update one table's data from another table (but skip identical records)

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

From: <gordon_at_panix.com>
Date: 12 Feb 2007 22:20:25 -0800
Message-ID: <1171347625.459833.278450@s48g2000cws.googlegroups.com>


Thanks! I'll give that a try.

Can a correlated update operate on more than one field at a time? And if not, would updating each field in a record result in several separate updates? I have a trigger that fires on updates, and it would be really nice to have just one trigger activation per record, even if that record has several fields to update. Received on Tue Feb 13 2007 - 00:20:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US