这是我的代码:

create or replace trigger th
after insert on stock
for each row
declare
    sqty number;
    rl number;
    isb number;
    rq number;
begin
    set sqty=(select stockqty from inserted);
    set rl=(select reorderlevel from inserted);
    set isb=(select isbn from inserted);
    set rq=(select reorderquantity from inserted);
go
if sqty> rl then
    delete from stock where isb=isbn;
    insert into stock values(isb,sqty,rl,rq);
end if;
end;

create or replace trigger t1
after insert on stock for each row
declare
    cursor cl is select isbn,stockqty,reorderlevel,reorderquantity from stock where isbn>0;
begin
    for c2 in c1 loop
    if c2.stockqty>c2.reorderlevel then
    delete from stock where isbn=c2.isbn;
    insert into stock values(c2.isbn,c2.reorderquantity,c2.reorderlevel,c2.reorderquantity);
end if;
end loop;
end;

最佳答案

我不知道您要做什么，但是您的语法是错误的(您从哪里获得的？SQL Server？)。有关正确的语法，请参见documentation。
你写了:

set sqty=(select stockqty from inserted);

sqty := :new.stockqty;

go

if sqty> rl then
    delete from stock where isb=isbn;
    insert into stock values(isb,sqty,rl,rq);
end if;

https://stackoverflow.com/questions/9919725/