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: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 15 Apr 2007 10:58:36 -0700
Message-ID: <1176659908.864385@bubbleator.drizzle.com>


Galen Boyer wrote:
> On Sat, 14 Apr 2007, damorgan_at_psoug.org wrote:

>> howa wrote:
>>> Seems AUTO_INCREMENT is very handy and natural, anyone agree?

>
> Has its merit. I like the way sequences are not tied to a single
> table. Gives one much more flexibility.
>
>
>> No. Autoincrement is a brain-damaged way of creating surrogate
>> keys.

>
> And what, may I ask, is the non-brain damaged way of using sequences?

I wasn't referring to sequences. I was referring to autoincrementing identity columns.

-- 
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 Sun Apr 15 2007 - 12:58:36 CDT

Original text of this message

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