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: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 26 Apr 2007 22:12:01 -0500
Message-ID: <u647iwcw7.fsf@rcn.com>


On Wed, 25 Apr 2007, damorgan_at_psoug.org wrote:
> 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.

Yet another disingenuous statement. In many situations BULK COLLECT and FORALL allow for far superior performance gains over cursor loops, so it behooves one to learn whatever they should learn to get the better performance benefits.

The scenario we are discussing in this thread, on the other hand, have no measurable diffence in performance. The only measurable parameter is maintainability of code.

-- 
Galen Boyer
Received on Thu Apr 26 2007 - 22:12:01 CDT

Original text of this message

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