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: Unique Column in Oracle 7.3

Re: Unique Column in Oracle 7.3

From: Ken Nichols <knichols_at_mcsilo.ilo.dec.com>
Date: 1997/09/24
Message-ID: <342901EC.6B09@mcsilo.ilo.dec.com>#1/1

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

Original text of this message

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