CREATE OR REPLACE TRIGGER t_xxx_xxx_trigger
before insert or update of tray_namestate on t_xxx_INFO
FOR EACH ROW
BEGIN
IF :OLD.tray_namestate != :NEW.tray_namestate THEN
:new.input_date := sysdate;
end if;
END;

posted on 2021-02-24 10:20  Apeak  阅读(747)  评论(0)    收藏  举报