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 - 15:30:38 CDT
