it is called a sequence number.
you can create it as 'create sequence' give the seed and increments.
look at the doc.
you can then select curval and nextval of sequence for a given table.
Bill Weaks wrote:
>
> Sounds silly, I suppose, but I can't find documentation on how to create
> an IDENTITY column in Oracle 7!
>
> I see ROWID, but that doesn't cut it.
>
> My experience thus far has been with MS SQL 6.5+, and they have a way to
> create an autoincrementing field in a table.
>
> Could somebody shed some light, please?
>
> Thanks
Received on Fri Nov 12 1999 - 18:45:28 CST
