Find duplicate rows

Find duplicate rows

 

  

Hi all,

I am sure this question has been asked many times but I don't seems to find it from archive, here goes again. How do find all the duplicate rows in a table?
thanks,

WZ
Oracle LazyDBA home page