【文件属性】:
文件名称:trigger触发器trigger触发器trigger触发器
文件大小:780B
文件格式:PDC
更新时间:2013-05-03 14:44:41
trigger触发器trigger触发器trigger触发器
--行级触发器
create or replace trigger insert_person
after insert on person
for each row
begin
insert into person2 values(:new.id,:new.name,:new.password);
end;
create or replace trigger update_person
after update on person
for each row
begin
update person2 set name=:new.name,password=:new.password where id=:new.id ;
end;
create or replace trigger delete_person
after delete on person
for each row
begin
delete from person2 where id=:old.id;
end;