Triggers
From: The Magnet <art_at_unsu.com>
Date: Sat, 7 Aug 2010 15:30:28 -0700 (PDT)
Message-ID: <dfb43f19-09a7-4538-924c-bda5be2dec5c_at_j8g2000yqd.googlegroups.com>
Date: Sat, 7 Aug 2010 15:30:28 -0700 (PDT)
Message-ID: <dfb43f19-09a7-4538-924c-bda5be2dec5c_at_j8g2000yqd.googlegroups.com>
Is there really any good way to track the changed columns in a trigger on an update?
Say I have a table of 100 columns and I am doing some history recording into another table for 50 of those columns. Putting 50 IF statements is lame. Is there a better way to do it?
Maybe something similar to
DECODE(email,:NEW.email, :NEW.email, :OLD.email)
Received on Sat Aug 07 2010 - 17:30:28 CDT