How to delete one row for each duplicate records ?

Question

In my tables I hve some duplicate rows. I want to remove duplicacy i.e. i want table that have different rows i.e. no duplicacy.

Answer 1

use ROWID in oracle...

Answer 2

you should have some incremental row column (field) in table design or you can add it. then run a query which capture only duplicate or more than one order with same primary key field. then set logic, only keep max or min number from (incremental filed) which you created in begning. In both cases (min or max) you will get rid of one line each and then you will have clean table. Next time in table design you can restrict on table design not to enter duplicate key by defining Primary Key.

Hope it'll help.