--建表
create table A(aaa varchar(20));
--建触发器
create or replace trigger A_biur
before insert or update
on A
for each row
begin
    if :new.aaa='accept' then
        :new.aaa:='report_accept';
    end if;
end;
/
--测试
insert into a values('accept');
select * from a;
update a set aaa='accept1';
select * from a;
update a set aaa='accept';
select * from a;
--完成

------解决方案--------------------
探讨


SQL code

--建表
create table A(aaa varchar(20));
--建触发器
create or replace trigger A_biur
before insert or update
on A
for each row
begin
    if :new.aaa='accept' then
        :new.aaa:='report_accept……