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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 25 Apr 2007 21:03:16 -0700
Message-ID: <1177560195.481439@bubbleator.drizzle.com>

Galen Boyer wrote:
> On Mon, 23 Apr 2007, damorgan_at_psoug.org wrote:
>

>> I think Oracle is remarkably easy to use given its power.

>
> And so do I. We are talking about a particular feature of the Oracle
> engine. Not the entire engine. The sequence is not as easy to
> implement than an autoincremeting datatype, plain and simple.

What I am saying that simple does not trump functional.

Array processing with BULK COLLECT and FORALL is more complicated than cursor loops. But it will be a cold day in heck before you see me implementing cursor loops again.

-- 
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 Wed Apr 25 2007 - 23:03:16 CDT