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: <hasta_l3_at_hotmail.com>
Date: 22 Apr 2007 23:03:34 -0700
Message-ID: <1177308214.849790.177460@y80g2000hsf.googlegroups.com>


On 23 avr, 07:07, hasta..._at_hotmail.com wrote:
> On 22 avr, 20:07, DA Morgan <damor..._at_psoug.org> wrote:
>
> > hasta..._at_hotmail.com wrote:
> > > What people would like is to *supplement* sequences
> > > with a declarative way to telloracle: Please provide
> > > a unique value for this primary key if none specified.
>
> > > Something like DB2, which - as I get it - has both
> > > SEQUENCEs and IDENTITY columns...
>
> > I can understand the allure of such but laziness being
> > what it is I would expect most developers to be lazy and
> > the quality of applications to suffer.
> > --
>
> Quite to the contrary, Daniel. The less code you write,
> the most solid an application is...
>
> Having to specify the correct sequence for a thousand
> inserts is a thousand opportunities for a bug.

Oops... Probably I misunderstood you, Daniel. Please ignore my follow-up.
Sorry.

Received on Mon Apr 23 2007 - 01:03:34 CDT

Original text of this message

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