触发器实现自动编号

 

•

 

• create or replace trigger Trig_TestSeq

• before Insert On TestSeq

• for each row

• declare AID int;

• begin

•   select seqid.nextval into AID from dual;

•   :new.AutoID:=AID;

• end;

• －－insert into testseq(name) values('test1')

create Table TestSeq
( AutoID INT,
  Name varchar2(20)
)
create sequence SeqID
  Start with 1
  increment by 1