Re: Generating Sequence Numbers

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