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: John Hunter <jthunter_at_nbnet.nb.ca>
Date: Fri, 11 May 2001 15:55:47 GMT
Message-ID: <7YTK6.1200$aW4.202727@news-nb00s0.nbnet.nb.ca>

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

Original text of this message

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