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

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 20 Apr 2007 23:38:21 +0200
Message-ID: <58sq6eF2im0qmU1@mid.individual.net>

On 15.04.2007 10:12, howa wrote:
> On 4月15日, 下午12時04分, "Fuzzy" <fuzzy.greybe..._at_gmail.com> wrote:

>> On Apr 14, 7:27 am, "howa" <howac..._at_gmail.com> wrote:
>>
>>> Seems AUTO_INCREMENT is very handy and natural, anyone agree?
>> Seems SEQUENCE is very handy and natural.  Why don't others implement
>> SEQUENCE?
>>
>> /Hans

>
> I can't agree SEQUENCE is more handy than AUTO_INCREMENT as you need
> to do the same thing by two statements.

That depends on how you do it. There is

insert into .... values ( ...., seq_xyz.next_val, ... )

robert Received on Fri Apr 20 2007 - 16:38:21 CDT