17,140
社区成员




create or replace trigger tri_DZ_HYZL_update
before update on dz_hyzl
for each row
declare
mdm varchar(30) := '005003';
begin
if updating('kmno') then
insert into modihis values(:new.bmdm,mdm,'kmno',:old.kmno,:new.kmno,sysdate,:new.xgry,:new.kmid);
end if;
if updating('name') then
insert into modihis values(:new.bmdm,mdm,'name',:old.name,:new.name,sysdate,:new.xgry,:new.kmid);
end if;
...
end tri_DZ_HYZL_update;
if updating('kmno') then
insert into modihis values(:new.bmdm,mdm,'kmno',:old.kmno,:new.kmno,sysdate,:new.xgry,:new.kmid);
end if;