create table temp111 (cid varchar2(100),cName varchar2(100));
create or replace trigger triTemp111
before insert on temp111
for each row
begin
if :new.cid='111' then
:new.cName:='123';
end if;
end;
insert into temp111(cid) values ('111');
select * from temp111
/////////////
cid cname
111 123