Triggers
From: The Magnet <art_at_unsu.com>
Date: Thu, 8 Jul 2010 11:49:33 -0700 (PDT)
Message-ID: <e1411c02-195b-4530-bd2c-9279cb7e271c_at_m35g2000prn.googlegroups.com>
Ok, probably a simple question but, say I have an after update on a table of maybe 20 columns, for each row.
Date: Thu, 8 Jul 2010 11:49:33 -0700 (PDT)
Message-ID: <e1411c02-195b-4530-bd2c-9279cb7e271c_at_m35g2000prn.googlegroups.com>
Ok, probably a simple question but, say I have an after update on a table of maybe 20 columns, for each row.
If a column in the source table is updated I should use the :NEW, right? And if it is not updated I assume I should use the :OLD?
I guess what I am getting is I do not know which columns are updated, so, how do I code the trigger to know which to use, :NEW or :OLD, since not all columns will be updated? Received on Thu Jul 08 2010 - 13:49:33 CDT