触发器,新增一条数据将其中的俩个字段写到另一张表对应的字段
程序员文章站
2024-02-22 23:27:52
...
CREATE OR REPLACE TRIGGER wastage_test
BEFORE INSERT ON ic_wastage_b
for each row
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
UPDATE dm_delivbill_b SET
nsignastnum=:new.noutsignastnum,nsignnum=:new.noutsignnum where cfirstbid=:new.cfirstbillbid;
commit;
END wastage_test;