create or replace trigger biufer_EMP_EXPERIENCE
before insert on HRM_EMP_EXPERIENCE
for each row
begin
select SEQ_EMP_EXPERIENCE.nextval
into :new.no
from dual;
end;我把for each row去掉,当insert时还是会 添加多条,并且条数不确定.
before insert on HRM_EMP_EXPERIENCE
for each row
begin
select SEQ_EMP_EXPERIENCE.nextval
into :new.no
from dual;
end;我把for each row去掉,当insert时还是会 添加多条,并且条数不确定.
执行上面的语句是其中的no是从序列SEQ_EMP_EXPERIENCE中取值的,但是它还会执行多行
insert into hrm_emp_experience (no,id,name) values(no,"","")
现在就是不要它执行这些多余的insert,怎么办?