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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Apr 2007 09:29:17 -0700
Message-ID: <1176568157.173637.123950@w1g2000hsg.googlegroups.com>

On Apr 14, 9:58 am, sybra..._at_hccnet.nl wrote:
> On 14 Apr 2007 06:27:46 -0700, "howa" <howac..._at_gmail.com> wrote:
>
> >Seems AUTO_INCREMENT is very handy and natural, anyone agree?
>
> No. Oracle has something called SEQUENCE which isn't bound to any
> column, or table. THIS is very handy.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I agree with Sybrand. As someone who every now and then has to work with SQL Server the auto-increment feature which has its advantages also has its fair share of disadvantages when dealing with the row data.

IMHO -- Mark D Powell -- Received on Sat Apr 14 2007 - 11:29:17 CDT