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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 23 Apr 2007 08:21:55 -0700
Message-ID: <1177341715.735273@bubbleator.drizzle.com>

Galen Boyer wrote:
> On Sun, 22 Apr 2007, damorgan_at_psoug.org wrote:

>> hasta_l3_at_hotmail.com wrote:
>>
>>> What people would like is to *supplement* sequences
>>> with a declarative way to tell oracle : 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.

>
> Come on Daniel. Sometimes you talk about how easy Oracle is to use over
> other products, but then when something is shown to be easier than how
> Oracle implements something you turn the argument around and say, well,
> its easiness shows how lazy people are and we should stick with the less
> easy solution.

When I go to a professional in any other field ... physician, lawyer, accountant, engineer, etc. I expect professional training, professional quality, and professional integrity.

When I go to a dentist I don't ask for the procedure that is easiest. Or the one that uses the smallest number of instruments or takes the least amount of time. I expect the one that gives me the best possibility of a successful outcome.

I think Oracle is remarkably easy to use given its power. But I also expect DBAs and Developers to be properly schooled in how to use that tool. No more or less than I would ask of my dentist.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Apr 23 2007 - 10:21:55 CDT