Re: unique id for a populated table

Try this:

Add a column UNQ_ID nuber;

update table_NAME set UNQ_ID = rownum;

This will populate the row with its rownum as the UNQ_ID. If you want you can append/convert and do multiple things with the rownum value to generate your UNQ_ID.

HTH Prasad Chavali
pchavali_at_assettech.com

Sajnish Gupta wrote in message <7c4bee$9le$1_at_mail1.wg.waii.com>...
>Hi,
>Is there a way I can create a sequential unique ID in a table that is
>populated with data.
>Thank you
>Sajnish
>
>
Received on Tue Mar 09 1999 - 19:12:10 CST