create or replace trigger tab_order_app_status
before update of status on TAB_ORDER_APP
for each row
declare
-- local variables here
begin
if nvl(:new.status, 0) = 1 and nvl(:old.status, 0) = 0 and
nvl(:new.FENDAN_TYPE, 0) = 0 then
insert into TAB_ORDER_FENDAN_TMP
(guid,
Order_Id,
Send_Man_Province,
Send_Man_City,
SEND_MAN_AREA,
SEND_MAN_ADDRESS_DETAIL,
ACCEPT_COMPANY)
values
(sys_guid(),
:new.order_id,
:new.send_man_province,
:new.send_man_city,
:new.send_man_area,
:new.send_man_address_detail,
:new.accept_company);
end if;
end tab_order_app_status;
怎么在这个触发器里面加一个当tab_order_appb表插入数据的同时往Tmp表插入一条数据呢
insert into TAB_ORDER_FENDAN_TMP ,改成 insert into tmp,后面的一样不就可以了吗,在:new.accept_company);后面加上 -_-|||