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
if :new.cid='111' then :new.cName:='123'; end if; :new.cid是什么意思?
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
:new.cName:='123';
end if;
:new.cid是什么意思?