触发器，新增一条数据将其中的俩个字段写到另一张表对应的字段
CREATE OR REPLACE TRIGGER wastage_testBEFORE INSERT ON ic_wastage_b for each rowdeclare PRAGMA AUTONOMOUS_TRANSACTION; begin UPDATE dm_delivbill_b SET nsignastnum=:new.noutsignastnum,nsignnum=:new.noutsignnum where cfirstbid=:new.cfirstbillbid;
