Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unique numeric column in Oracle V7.3
try using a sequence and a trigger to select from the sequence
On Tue, 23 Sep 1997 15:53:33 +0100, Ian Douglas <idouglas_at_NLIS.ORG.UK> wrote:
>I am an Oracle newbie. Could someone please tell me how to create a
>column with in an Oracle Table that has an automatically unique
>sequential number. I have looked at the rowid column, but this is no
>good to me because I need to specify the column name.
>
>
>Any help in what must surely be a very simple operation would be
>appreciated.
Received on Wed Sep 24 1997 - 00:00:00 CDT