Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Autoincrement in Oracle 8.1.7

Re: Autoincrement in Oracle 8.1.7

From: Andre van Winssen <andrew01-no-spam_at_xs4all-fck-spam.nl>
Date: Sun, 28 Apr 2002 20:31:27 +0100
Message-ID: <aahim9$c9s$1@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 - 14:31:27 CDT

Original text of this message

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