--建立触发器 create or replace trigger myfirsttriger before update or insert or delete on 计费1019结果 for each row begin if inserting then insert into ct1019_cdr(主叫号码) values(:new.主叫号码); dbms_output.put_line('insert'); end if;
if updating then update ct1019_cdr set 主叫号码=:new.主叫号码 where 主叫号码=:old.主叫号码; dbms_output.put_line('update'); end if;
if Deleting then delete from ct1019_cdr where (主叫号码=:old.主叫号码); dbms_output.put_line('Delete'); end if; end; ----测试触发器 insert into 计费1019结果(主叫号码) values('259122281910')update 计费1019结果 set 主叫号码='159122281910' where 主叫号码='059122281910'delete from 计费1019结果 where 主叫号码='259122281910'--------------------- select * from 计费1019结果 where 主叫号码='259122281910'select * from ct1019_cdr where 主叫号码='259122281910'
after :insert into ta 以後
2。改成after,可能会出错
create or replace trigger myfirsttriger
before update or insert or delete
on 计费1019结果
for each row
begin
if inserting then
insert into ct1019_cdr(主叫号码)
values(:new.主叫号码);
dbms_output.put_line('insert');
end if;
if updating then
update ct1019_cdr
set 主叫号码=:new.主叫号码
where 主叫号码=:old.主叫号码;
dbms_output.put_line('update');
end if;
if Deleting then
delete from ct1019_cdr where (主叫号码=:old.主叫号码);
dbms_output.put_line('Delete');
end if;
end;
----测试触发器
insert into 计费1019结果(主叫号码)
values('259122281910')update 计费1019结果
set 主叫号码='159122281910'
where 主叫号码='059122281910'delete from 计费1019结果
where 主叫号码='259122281910'---------------------
select *
from 计费1019结果
where 主叫号码='259122281910'select *
from ct1019_cdr
where 主叫号码='259122281910'