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 Fri, 27 Apr 2007, damorgan_at_psoug.org wrote:
> Galen Boyer 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.
> > I don't see any evidence that your statement "have no measurable > diffence in performance" is valid. The history of autoincrementing > columns would indicate otherwise. IIRC one of the first things IBM > did with Informix was add sequences.
Fer Chists sake...
Whatever, jump around all you want Daniel. I'm sure Oracle will implement an autoincrementing column using sequences some day, and then you will be touting just how great they are, but until they do, you will tout that autoincrementing sequences are bad developer habits, poorly architected solutions and just continue to market the koolaid for every single damn piece of functionality that Oracle puts out.
-- Galen BoyerReceived on Sat Apr 28 2007 - 08:38:05 CDT