To update a table acc to duplicate values

Hi all,


To update duplicate records in a table
suppose if we take a dept table where deptno 10 is duplicated 3 times whose dname as accounting, den we have to update its dname as accounting1 for 1st record,accounting2 for 2nd record & accounting3 for 3rd record.

like wise we hav 2 update all the duplicate records in such manner

thanks...

Sany