交换系统防止重复插入数据

在插入数据之前先删除重复的数据

create or replace trigger tri__House
before insert on t__House
 FOR EACH ROW
 
declare
 pragma autonomous_transaction;
begin

delete from t__House where pkid=:NEW.pkid;
commit;

end;