The create or replace the trigger ZDY_KCRKD1_ZDZG
After the insert or update on KCRKD1
For each row
Declare

The begin

if the update: new KCRKD1_KCJZ='1'
Then
UPDATE KCRKD1 SET KCRKD1_ZGBZ='1' where KCRKD1_PJLX='G' AND KCRKD1_YWBS <> 'CGRKD AND KCRKD1_KCJZ=' 1 'AND kcrkd1_lsbh=: new. Kcrkd1_lsbh;
end if;

End ZDY_KCRKD1_ZDZG;