文件名称：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;