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 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.