Re: Autoincrement in Oracle 8.1.7

Bravo.

Actually, given that you can cache sequences etc. I am not so quick to assume that an auto identiy is faster. I bet sequence on a Sun box is faster than on a Win 2K box. Not fair you say because SQL Server doesn't run on Sun. Then put in an enhancement request to MS to expand their platforms. I know, I know it would be a cold day in the nether regions before that would happen.

Jim
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ucot31oq1q5t9d_at_corp.supernews.com...
> If you want to turn Oracle into Sqlserver this is of course a perfect
> request.
> However, a sequence is not bound to any particular column and any
particular
> table, and this is actually a good thing, as it has it's uses.
> I'm sure the identity feature is not going to beat the sequence in terms
of
> performance. It has however some advantages for people who don't use
> Designer, and think that coding a less than 10 line row level trigger is
> asked too much from them.
>
> Regards
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
> "Andre van Winssen" <andrew01-no-spam_at_xs4all-fck-spam.nl> wrote in message
> news:aahim9$c9s$1_at_news1.xs4all.nl...
> > In sqlserver you have the 'identity' feature. Oracle lacks such. It
would
> be
> > worth
> > an enhancement request. It's probably much faster than a sequence and a
> row
> > level INSERT trigger.
> >
> > Regards,
> > Andre
> >
> >
> > "Dave" <davep_at_centurysystems.net> schreef in bericht
> > news:3CC995CE.A045A32D_at_centurysystems.net...
> > > Hello.
> > >
> > > I am fairly new to Oracle, can anyone tell me if there is a way to
> > > create a column (primary key) that the database itself will fill in
> > > automatically with a sequential number ?
> > >
> > > Thanks in advance
> > >
> > >
> > >
> >
> >
>
>
Received on Sun Apr 28 2002 - 18:27:02 CDT