CREATE TRIGGER tri_OperateTime
AFTER INSERT OR UPDATE ON TableTest
FOR EACH ROW
begin
IF INSERTING THEN :new.OperateTime :=sysdate; END IF;
IF UPDATING THEN :new.OperateTime :=sysdate; END IF;
end;
CREATE TRIGGER tri_OperateTime
AFTER INSERT OR UPDATE OF age ON Person
FOR EACH ROW
begin
IF INSERTING THEN :new.idate :=sysdate; END IF;
IF UPDATING THEN :new.idate :=sysdate; END IF;
end;