触发器

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;