触发器.txt

很简单的小程序

 create or replace trigger slchg
 after insert on jhand
 for each row
 begin
 update base set jsl=jsl-:new.hsl
 where jid=:new.jid;
 end;