Oracle触发器

为什么80%的码农都做不了架构师？>>>   

##触发器示例：

删除触发

create trigger del_deptid 
after delete on deptment
for each row 
begin
delete form emp where id=:old.id;
end del_dept id;
/

插入触发

create or replace trigger insert_a_b
after insert on a
for each row
begin
insert into b(id) values('d');
end
/

更新触发

create or replace trigger update_a_b
after insert on a
for each row 
begin
insert into b(id) values( '1');
end
/

综合案例：

--表
create table mylog(
curr_user varchar2(100),
curr_date date,
act char(1)
);

create or replace trigger mylog_aa
after insert or delete or update on a
--for each row
begin
if inserting then
insert into mylog values(user,sysdate,'1');
else deleting then
insert into mylog values(user,sysdate,'d');
else 
insert into mylog values(user,sysdate,'u');
end;
/

create or replace trigger mylog_aa
after insert or delete or update on a
--for each row
begin
insert into mylog values(user,sysdate,'1');
end;
/

转载于:https://my.oschina.net/csmw00/blog/673345