Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Column in Oracle 7.3
Ian,
You need to combine a sequence with a trigger. If you don't know how to do this, email me.
Ken
Ian Douglas 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.
> --
> --
> Ian Douglas
Received on Wed Sep 24 1997 - 00:00:00 CDT
![]() |
![]() |