Create Or Replace Trigger tr_ti_pfxsjl
Before insert
On PFXSJL
Begin
if
GHDW IN ('60002', '60003','60004','60005','60006','60010', '60011') AND THFS = 0
then
raise_application_error(-20001,'批发类型不对!请选择自提批发!');
end if;
End;
Before insert
On PFXSJL
Begin
if
GHDW IN ('60002', '60003','60004','60005','60006','60010', '60011') AND THFS = 0
then
raise_application_error(-20001,'批发类型不对!请选择自提批发!');
end if;
End;
BEFORE INSERT ON PFXSJL
FOR EACH ROW
BEGIN
IF instr(',60002,60003,60004,60005,60006,60010,60011,', ',' || GHDW || ',') > 0 AND THFS = 0 THEN
raise_application_error(-20001, '批发类型不对!请选择自提批发!');
END IF;
END;
CREATE OR REPLACE TRIGGER tr_ti_pfxsjl
BEFORE INSERT ON PFXSJL
FOR EACH ROW
BEGIN
IF instr(',60002,60003,60004,60005,60006,60010,60011,', ',' || :new.GHDW || ',') > 0 AND
:new.THFS = 0 THEN
raise_application_error(-20001, '批发类型不对!请选择自提批发!');
END IF;
END;
insert 用到new 表,delete 用到 old表,update用到new和old 表