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;
?
