If any of the first 3 columns get update, I want the changed date to update.
Expand|Select|Wrap|Line Numbers
- CREATE TRIGGER MyTestTrigger
- AFTER UPDATE of "column1", "column2", "column3"
- ON Mytable REFERENCING OLD AS OLD NEW AS NEW
- FOR EACH ROW
- begin
- IF UPDATING THEN
- UPDATE Mytable
- SET CHANGED_DT = SYSDATE;
- END IF;
- END;
- /
However, I am getting the mutuating error. Why?