Re: tell updated fields from within a trigger - how ?

From: TNasset <tnasset_at_aol.com>
Date: 23 May 1998 18:35:49 GMT
Message-ID: <1998052318354900.OAA25196_at_ladder03.news.aol.com>


>Is there a way to tell what fields an update statement is trying to update
from within a pre-update trigger ?
>
>

If you are using a database pre-update trigger you can compare the new value to the old value to see if it is different. i.e. If :new.field1 != :old.field1 then you know that field1 is being updated. Received on Sat May 23 1998 - 20:35:49 CEST

Original text of this message