oracle中:
CREATE OR REPLACE TRIGGER te_acpt_bill_batch_insert_tg BEFORE INSERT ON te_acpt_bill_batch FOR EACH ROW
BEGIN
:new.update_dt := to_char(sysdate,'YYYYMMDD');
:new.update_tm := to_char(sysdate,'HH24MISS');
END;
/
iteye_21260的博客 --监控某个表,当数据插入到表后,执行触发...CREATE trigger tri_ins_UB_ORGINFO after INSERT ON UB_ORGINFO --for insert REFERENCING NEW AS n FOR EACH ROW --MODE DB2SQL BEGIN ATOMIC delete ...
假装80后的博客This article will discuss the trigger on a view, other than a table. Firstly, let's define updatable view, then continue define trigger on view. 1. Updatable View Most of, but the simplest,