create or replace trigger TRG_testA before
insert or update of id,name on testA
for each row
begin
--if rownum<3 then
select 1 into :new.flag2 from dual;
-- end if;
end;
create table testA(id number(4),name varchar(3),flag2 number(4));
insert into testA(id,name,flag2) values(1,'111',0);
update testA set name='222';
update testA set flag2=0;
select * from testA;