create or replace trigger tri_upd after insert on tablename1 for each row declare cursor mycur is select * from tablename2; myrec tablename2%rowtype; begin open mycur;--打开游标 fetch mycur into myrec; while mycur%found loop fetch mycur into myrec; if(myrec.columnname2=:new.columnname1) then update tablename2 set flag=true where id=myrec.id; commit; end if; end loop; close mycur; end;
CREATE OR REPLACE TRIGGER tr_check AFTER insert on checksFOR EACH ROW --说明创建的是行级触发器BEGIN --将修改前数据插入到日志记录表 del_emp ,以供监督使用。 update enterprise set enterprise.checked='1' where enterprise.checkauthor=:new.check_name and enterprise.id=:new.enterprise_id; END;
create or replace trigger tri_upd
after insert on tablename1
for each row
declare
cursor mycur is select * from tablename2;
myrec tablename2%rowtype;
begin
open mycur;--打开游标
fetch mycur into myrec;
while mycur%found loop
fetch mycur into myrec;
if(myrec.columnname2=:new.columnname1) then
update tablename2 set flag=true where id=myrec.id;
commit;
end if;
end loop;
close mycur;
end;
AFTER insert on checksFOR EACH ROW --说明创建的是行级触发器BEGIN
--将修改前数据插入到日志记录表 del_emp ,以供监督使用。
update enterprise set enterprise.checked='1' where enterprise.checkauthor=:new.check_name and enterprise.id=:new.enterprise_id;
END;