Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why Oracle don't have AUTO_INCREMENT as in MySQL
On 4月15日, 下午12時04分, "Fuzzy" <fuzzy.greybe..._at_gmail.com> wrote:
> On Apr 14, 7:27 am, "howa" <howac..._at_gmail.com> wrote:
>
> > Seems AUTO_INCREMENT is very handy and natural, anyone agree?
>
> Seems SEQUENCE is very handy and natural. Why don't others implement
> SEQUENCE?
>
> /Hans
I can't agree SEQUENCE is more handy than AUTO_INCREMENT as you need to do the same thing by two statements.
Also, in real world, use of AUTO_INCREMENT as primary key (e.g. id) is in fact, quite intuitive. Received on Sun Apr 15 2007 - 03:12:05 CDT