Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Triggers to Update Calculated Fields
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:16:46 CST
![]() |
![]() |