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 whe