CREATE OR REPLACE TRIGGER TR_TBL_USER BEFORE INSERT OR UPDATE on TBL_USER FOR EACH ROW
BEGIN
:NEW.LASTMODIFIEDTIME := SYSDATE;
END;
/
更新插入时,用触发器更新【最后更新时间字段】
最新推荐文章于 2021-01-18 11:27:30 发布
CREATE OR REPLACE TRIGGER TR_TBL_USER BEFORE INSERT OR UPDATE on TBL_USER FOR EACH ROW
BEGIN
:NEW.LASTMODIFIEDTIME := SYSDATE;
END;
/