17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER "KSOURCE".TRUSERINFO_INSERT AFTER
INSERT ON "KSOURCE"."USERINFO" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
Declare
v_SerialNum Number;
Begin
Select Count(*) Into v_SerialNum From UserInfo Where DepartID=:New.DepartID;
if (:New.SerialNum <> v_SerialNum) Then
Update UserInfo Set SerialNum=v_SerialNum Where UserID=:New.UserID;
end if;
End;