Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> duplicate rows in big table

duplicate rows in big table

From: James <jialong.x.xie_at_boeing.com>
Date: Wed, 30 Aug 2000 18:24:52 GMT
Message-ID: <G04B63.4HD@news.boeing.com> 






I have a table, which has more than one million rows but a few duplicates.
Is there any quick way to single out these duplicates? The normal way that
compares rowid by rowid is too time consuming. Any help will be appreciated.



James
Received on Wed Aug 30 2000 - 13:24:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US