Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |