create or replace trigger tr_before_insert_employee
after insert
on t_employees
for each row
begin
:new.work_years :=0;
end;
执行插入语句
insert into t_employees values(employee_seq_nextval,'小龙女',6,'ACT');
把after改成before
create or replace trigger tr_before_insert_employee
before insert
on t_employees
for each row
begin
:new.work_years :=0;
end;
执行插入语句
insert into t_employees values(employee_seq_nextval,'大龙女',6,'ACT');这两种模式有什么相同点和不同点呀。
从结果上看,没有什么不同,最后的插入的6都被改成了0
请求指点,谢谢!
AFTER 先插入,后更改--------如果不能插入,值不会被更改
after insert
on t_employees
for each row
begin
:new.work_years :=0;
end;这个你能编译过去???
已经insert进去了你就修改不了:new的值了
你的触发器可以成功? 一没用自治事务 --这样才行
create or replace trigger tr_before_insert_employee
before insert or update of work_years on t_employees for each row
begin
:new.work_years :=0;
end;
before insert or update of work_years on t_employees for each row
begin
:new.work_years :=0;
end;