写一个触发器但一张表删除 将这张表数据存入另一张表,但另一张表还有两个没定义的字段
CREATE OR REPLACE TRIGGER "APPUSER"."tri" AFTER DELETE ON "CZJ_DS_MSG" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE
BEGIN
insert into CZJ_YS_MSG(yid,e_tel,content,stime,p_id,s_tel,v1,v2,v3,i1,i2)
select * from CZJ_DS_MSG
insert into CZJ_YS_MSG(state,description) values(-1,null)
END ;
qq_26771275
2016/03/31 07:28- 触发器
- 点赞
- 收藏
- 回答
0个回复
