Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why Oracle don't have AUTO_INCREMENT as in MySQL

Re: Why Oracle don't have AUTO_INCREMENT as in MySQL

From: howa <howachen_at_gmail.com>
Date: 15 Apr 2007 01:12:05 -0700
Message-ID: <1176624725.328374.286810@d57g2000hsg.googlegroups.com>


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

Original text of this message

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