Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Autonumber trigger

Re: Autonumber trigger

From: Dmitry Lesov <les_at_akanewmedia.com>
Date: Fri, 11 May 2001 18:28:55 GMT
Message-ID: <3AFC2FD7.7BAA5F89@akanewmedia.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US