Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Sequence for Auto Number
In our last gripping episode jkipp_at_my-deja.com wrote:
>
> > >
> >
> > If you are not coding an application to perform such duties then,
yes,
> > a trigger will be necessary to populate your 'auto-number' column.
And
> > this can be tricky, as you may well receive 'mutating table' errors.
> > To alleviate this you should visit
> > http://govt.us.oracle.com/~tkyte/Mutate/index.html where Tom Kyte
> > discusses this and provides excellent solutions.
> >
> > If you are coding an application to insert/update/delete/select data
> > from your table then a database trigger will not be necessary. Code
> > your application to utilize the sequence to populate the 'auto-
number'
> > column:
> >
> > ...
> > select auto_seq.nextval
> > into new_seq
> > from dual;
> > ...
> > insert into ....
> > values
> > (new_seq, :blk1.value, :blk1.value2, ...)
> > ...
> >
> > Of course, this example is for Oracle Forms (thus the :blk1
> > descriptors), but any application would be coded to perform similar
> > operations.
> >
> ------------
>
> All of the data will be entered via an Access form. So with this in
> mind, could I just tell Access to auto-increment in the form or do I
> still need to do something on the ORacle end?
>
> THanks
> Jim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
I believe you can ask Access to generate values for a column but don't quote me on that -- check your documentation. It may be that Access will need the sequence to generate numbers.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Mon Nov 20 2000 - 14:12:02 CST
![]() |
![]() |