Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> update triggers to update same table
We have a table with a key1, key2, figure1, calcul1 fields.
What I want to do is an update trigger that when a row is updated or a new one is inserted that it calculates the calculated field calcul1 dpending on other row in that table.
But what happens? As the lines is updated oracle starts the trigger and updates the calculated field, so the row is again updated and it starts again the trigger or is that a wrong consumption?
Wim Received on Thu Oct 07 1999 - 06:50:40 CDT