Skip to Main Content
Forums

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!

how to update duplicate id?

821674Dec 22 2010 — edited Dec 22 2010
Hi friends,

I have a table EMP with duplicate IDs.

For example:

ID
----

100
100
200
200
200


To make it unique, I would like to concatenate at the end of each a sequence-no or rownum, like this desired output:

ID
---

1001
1002
2001
2002
2003


How do I write a sql to do this?


Thanks a lot,

Ms Inday
This post has been answered by Solomon Yakobson on Dec 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2011
Added on Dec 22 2010
18 comments
478 views