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;
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/281792.html
標籤:基礎和管理