software






 

Question by  mixedup (64)

Why using Oracle SQL, how do I delete duplicate rows?

 
+5

Answer by  gigo (1706)

If you want to do an CREATE UNIQUE INDEX, Oracle will not do the job when there are duplicate rows. MySQL can do that and eliminates the redundant data. So: export the table to mysql, do it and re-import it!

 
You have 50 words left!