Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unique numeric column in Oracle V7.3

Re: Unique numeric column in Oracle V7.3

From: <drippel_at_perspect.com>
Date: 1997/09/24
Message-ID: <342a2969.2513123@news.erols.com>#1/1

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

Original text of this message

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