在SQLPLUS下,运行下面脚本,出错吗? create or replace trigger ins_login after insert on login referencing old as old new as new for each row declare numb number; i number; begin numb := 1; while numb < 6 loop select hold_id.nextval into i from dual; insert into hold_type values(i,numb,:new.id,null); numb := numb + 1; end loop; end;
create or replace trigger ins_login
after insert on login
referencing old as old new as new for each row
declare
numb number;
i number;
begin
numb := 1;
while numb < 6 loop
select hold_id.nextval into i from dual;
insert into hold_type values(i,numb,:new.id,null);
numb := numb + 1;
end loop;
end;
那也是一个序列,本来应该是hold_id,不小心写错了!!