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

Home -> Community -> Usenet -> c.d.o.server -> Triggers and calculated fields

Triggers and calculated fields

From: Michael <Michael.Wrobel_at_unisys.com>
Date: Wed, 8 Dec 1999 18:17:17 -0500
Message-ID: <82mog4$o5g$1@mail.pl.unisys.com>


I want to use triggers to update calculated fields. I am creating a trigger for each row after an insert, update, or delete. Something with the trigger is not going through because no updates that were specified in the trigger are happening. Has anyone used triggers to keep calculated fields updated. Is there a recommended strategy?

I have 6 fields and if any are inserted, updated, or deleted, I want to run an automatic recalculation for 2 calculated fields. I have been attempting the recalculation with an update clause inside of the trigger.

Thanks,

Mike Received on Wed Dec 08 1999 - 17:17:17 CST

Original text of this message

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