oracle insert 触发器临时数据 保存在 ":new" 中
delete 触发器临时数据保存在 ":old" 中
如:
CREATE OR REPLACE TRIGGER tr_letterReply
AFTER INSERT
ON NET_PETITION_REPLY_SHOW for each row
BEGIN
INSERT INTO letter_reply(
petition_event_uuid,
inner_petition_event_uuid,
reply_show_title,
reply_show_content,
reply_show_time,
show_reply,
show_pro_result
) values
(
:new.petition_event_uuid,
:new.inner_petition_event_uuid,
:new.reply_show_title,
:new.reply_show_content,
:new.reply_show_time,
:new.show_reply,
:new.show_pro_result
);
END tr_letterReply ;