Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert unique numbers for each row...

517920Feb 15 2012 — edited Feb 15 2012
Hi,

I have one table having over 100K records. I want to add new column and want to insert serial number/unique numer for each row.
Could you please let me know what is the best way to implement this?

Thanks...

Regards,
Suman S

Edited by: SSN on Feb 15, 2012 1:32 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2012
Added on Feb 15 2012
7 comments
3,894 views