Re: Auto increment identity column?
From: Ed prochak <ed.prochak_at_alltel.com>
Date: 25 Apr 2002 14:14:55 -0700
Message-ID: <e51b160.0204251314.5ec45e99_at_posting.google.com>
Date: 25 Apr 2002 14:14:55 -0700
Message-ID: <e51b160.0204251314.5ec45e99_at_posting.google.com>
Ken Denny <ken_at_kendenny.com> wrote in message news:<Xns91FACF59DEABCkendenny_at_65.82.44.7>...
> mitra928_at_hotmail.com (mitra fatolahi) wrote in
> news:4022442f.0204241551.59142921_at_posting.google.com:
>
> > Does Oracle database has the Auto Increment identity column feature
> > like MS SQL Server? I want to use it as the Primary key for my table.
>
> Use a sequence. The syntax to create it is here:
> http://www.ss64.demon.co.uk/ora/sequence_c.html
> When you insert into the table, insert sequence_name.NEXTVAL into the
> primary key column.
Why do you plan on using the sequence number as a primary key?
Please consider this carefully as you design your tables. Received on Thu Apr 25 2002 - 23:14:55 CEST