•
•
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')
( AutoID INT,
Name varchar2(20)
)
create sequence SeqID
Start with 1
increment by 1