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: How do I create an Auto Increment Column?

Re: How do I create an Auto Increment Column?

From: vurley <vurley_at_163.net>
Date: Fri, 7 Jan 2000 13:08:31 +0100
Message-ID: <3876b915.0@dnews.sbell.com.cn>


Try 'LONG RAW' datatype in ORACLE.

rxb1 wrote in message <3875190E.212B3659_at_lucent.com>...
>Does anyone know how to create a column that will automatically
>increment
>every time new data is added to the field. Similar to MS Access
>AutoNumber data type or even
>like SQL Server IDENTITY property on the column.
>
>I need to create a table that can be used in sqlserver and Oracle 8i
>that will function similarly from
>an application accessing it using ADO. The tables do not have to
>implement the auto increment the same,
>but the application accessing it has to work independantly of the
>Database.
>
>Thanks,
>Rich
>
Received on Fri Jan 07 2000 - 06:08:31 CST

Original text of this message

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