Hi,i'm writing sql trigger that updates some columns in table. I have to write that this trigger fires only after commit. I read some articles about this topic but in the most it is said to use procedure. But I have to do it with trigger.
CREATE OR REPLACE TRIGGER tr_reset_er_encours
AFTER INSERT OR UPDATE ON T
FOR EACH ROW
BEGIN
IF (:NEW.T.var1)=0
THEN UPDATE T
SET var1=NULL
END IF;
END;