CREATE OR REPLACE TRIGGER add8hour 2 BEFORE INSERT ON test 3 FOR EACH ROW 4 DECLARE 5 BEGIN 6 :new.time := :NEW.TIME+1/3; 7 END; 8 /