急急急!oracle触发器如何写A表插入数据 B表更新某字段

2024-10-28 17:45:01
推荐回答(1个)
回答1:

CREATE or replace TRIGGER tri_contract_zf
after INSERT ON gfxt_bill
FOR EACH ROW
BEGIN
UPDATE gfxt_contract
SET contract_zt ='轿隐提单闭伏厅厅脊开出'
WHERE contract_id=:ROW.contract_id;

END;