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>
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