Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Autonumber trigger
Create a sequence a_seq,
put this into the before insert trigger:
Select a_seq.nextval into :new.field from dual;
-John
"Dmitry Lesov" <les_at_akanewmedia.com> wrote in message
news:3AFBFF3F.DF35999C_at_akanewmedia.com...
> I need to to write a trigger that duplicates Autonumber in MS Access -
> Id Field gets nextval from the sequence upon insert. But I don't know
> how to write a trigger that does that. Appreciate any help.
> Dmitry
>
Received on Fri May 11 2001 - 10:55:47 CDT