这个触发器如何写 oracle ( 积分: 50 )

两个表：CGDHD1&nbsp;&nbsp;CGDHD2&nbsp;&nbsp;都是已经保存，修改CGDHD1的时候触发：UPDATE<br>两个表相关条件：CGDHD1_LSBH=CGDHD2_LSBH&nbsp;（流水编号）<br>当字段CGDHD1_ddjsf&nbsp;&nbsp;发生改变以后，自动更新CGDHD2_xgdx:需改字段：&nbsp;CGDHD2_xgdx=CGDHD1_ddjsf<br>条件还是CGDHD1_LSBH=CGDHD2_LSBH;

update&nbsp;CGDHD2&nbsp;set&nbsp;xgdx&nbsp;=&nbsp;:new.ddjsf&nbsp;where&nbsp;CGDHD2.LSBH&nbsp;=&nbsp;:new.LSBH<br>如果保存修改前值的话把&nbsp;:new&nbsp;改成&nbsp;ld