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: Daniel Noelte <leu_at_berlin.snafu.de>
Date: 1997/09/24
Message-ID: <34285347.CE1659EE@berlin.snafu.de>#1/1

A real automatic is not available. Use sequences for generate unique primary keys.

Daniel

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