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 -> Re: Identifying duplicate records

Re: Identifying duplicate records

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 06 Mar 2006 21:26:13 GMT
Message-Id: <pan.2006.03.06.21.26.13.140555@sbcglobal.net> 





On Mon, 06 Mar 2006 09:52:00 -0800, simpsonj_at_imsweb.com wrote:



> Hi everyone, I have a table that contains duplicate records.  All of

> the fields in these records are duplicates except for the primary key.

> I need to identify these records by their primary key.  Can anyone help

> me with this?  Thanks ahead of time.




Just truncate the table. Given the information you provided, it's the
fastest way.


-- 
http://www.mgogala.com


Received on Mon Mar 06 2006 - 15:26:13 CST












Original text of this message













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