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: Generating Sequence Numbers

Re: Generating Sequence Numbers

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Sep 1999 19:12:26 +0100
Message-ID: <938024116.10624.0.nnrp-14.9e984b29@news.demon.co.uk>


Sounds like:

    alter table your_table add (id_column number(15));

    update your_table set id_column = rownum;

would do what you need

It could be a bit heavy on rollback and row-chaining though.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Kevin Mackie wrote in message <7sb3ml$j5h$1_at_nnrp1.deja.com>...
>I need a new column on a table which will act like ROWID, so each row
>has a unique integer (which is between 1 and the number of rows in the
>table).
>
Received on Wed Sep 22 1999 - 13:12:26 CDT

Original text of this message

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