大拿幫忙看看這個(gè)語句有問題嗎?
create or replace trigger tiaojia
? after insert on bms_entry_pralter_dtl??
? for each row when :NEW.PRICEID=144
begin
? ? insert into bms_entry_pralter_dtl(ALTERDTLID,ALTERDOCID,PRICEID,GOODSID,fromprice,toprice,zx_saprice)?
? ? values (bms_entry_pralter_dtl_tmp_.nextval,:NEW.Alterdocid,106,:NEW.Goodsid,:NEW.Fromprice,:NEW.Toprice,:NEW.zx_saprice)
end tiaojia;
2021-10-26
不是大拿,不過沒看出什么問題??