Create or Replace Trigger DeleGetpassengertotal
before insert on z_getpassengertotal --监听表插入前
for each row --行触发器
declare
integrity_error exception;
errno integer;
errmsg char(200);
--执行PL/SQL块
begin
delete from z_getpassengertotal t
where t.columnvalue4 = :NEW.columnvalue4 and TO_CHAR(t.gathertime,'yyyy-mm-dd')=TO_CHAR(:NEW.gathertime,'yyyy-mm-dd'); --columnvalue4为线路名称(LINENAME)
--捕获异常
exception
when integrity_error then
raise_application_error(errno, errmsg);
end;