很明显这个问题要用触发器trigger来处理,可在pl/sql块里面来实现。参考代码
create or replace trigger del_ins
before delete on messageReceived
for each row
declare
begin
insert into messageGarbage(id,name,email,title,time,content)
values(:OLD.id,:OLD.name,:OLD.email,:OLD.title,:OLD.time,:OLD.content);
end;
11楼和15楼的兄弟好像把old写成new了。没记错的话这里应该用old。
create or replace trigger insert_dc_sell
before delete on messageReceived
for each row
declare
begin
insert into messageGarbage(id,name,email,title,time,content)
values(:NEW.id,:NEW.name,:NEW.email,:NEW.title,:NEW.time,:NEW.content);
end insert_dc_sell;
create or replace trigger insert_dc_sell
after delete on ivr_call_client
for each row
declare
begin
insert into dc_sell(ID,phone,result,selltime,operation)
values(:NEW.ID,:NEW.calltel,:NEW.state,:NEW.registerdate,:NEW.operation);
end insert_dc_sell;