Re: Question about Sequence Numbers

Thanks for all your help! I've now gotten it to work :)

"Kevin P. Fleming" wrote:

> You need to create a BEFORE INSERT trigger on that table to select the
> sequence's NEXTVAL and populate your primary key field. It's pretty simple,
> and there are good examples in the Oracle documentation.
>
> ogillert wrote in message <36F92AAF.FAFCAD13_at_delanotech.com>...
> >How do I get a table to automatically use a sequence number? I have a
> >table with a field that will always be populated be a sequence number.
> >But instead of doing it in the Insert statement I want it to
> >automatically generate this number. In other words how do I get Oracle
> >to do what MS Access does using an 'Autonumber' field and SQLServer does
> >using an 'Identity' field. Any help would be greatly appreciated.
> >
> >Thanks in advance,
> >Oliver Gillert
> >
Received on Thu Mar 25 1999 - 15:12:11 CET