Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Autonumber trigger
Thanx a bunch. Best Regards
Dmitry Lesov.
John Hunter wrote:
> 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 - 13:28:55 CDT
![]() |
![]() |