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, 22 Apr 2007 11:07:18 -0700
Message-ID: <1177265238.644360@bubbleator.drizzle.com>


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.

-- 
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 22 2007 - 13:07:18 CDT

Original text of this message

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