ORACLE 当修改某个字段值为1时触发另外一个字段值也为1,怎么写?
create or replace trigger ZDY_KCRKD1_ZDZG
after insert or update on KCRKD1
for each row
declare
begin
if 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;