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

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. Received on Mon Apr 23 2007 - 00:07:01 CDT