Question

How can i delete the duplicate rows in oracle table using rowid?

Answer 1

Answer:

hi, here is the answer

Explanation:

Method 3 Deleting Multiple Duplicates

Select the RowID you want to delete. After "SQL," enter "select rowid, name from names;."

Delete the duplicate. After "SQL," enter "delete from names a where rowid > (select min(rowid) from names b where b.name=a.name);" to delete duplicate records.

Check for duplicates.

for more details visit m.wikihow.com , that is my personally handled web page :)