--行级触发器
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;
