CREATE OR REPLACE TRIGGER "MYUSAP".TR_USAP_USER_ROLE_INDATE_TIME
before INSERT OR UPDATE ON TB_USAP_USER_ROLE_LINK FOR EACH ROW
BEGIN
IF INSERTING THEN
:NEW.link_indate := SYSDATE;
ELSIF UPDATING then
:NEW.link_indate := SYSDATE;
END IF;
END;
oracle插入修改触发器改变时间
最新推荐文章于 2023-04-07 16:28:20 发布