Re: find duplicate records (?)

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 26 Jul 2001 10:23:41 +0200
Message-ID: <9jok2e$34d$1_at_s1.read.news.oleane.net>

Fastest way has been given by Yaroslav Perventsev p_yaroslav_at_cnt.ru two days ago in a reply to a post titled "How to find Duplicate records":

CREATE TABLE exception
 (

  row_id                     ROWID,
  owner                      VARCHAR2(30),
  table_name                 VARCHAR2(30),
  constraint                 VARCHAR2(30)

 )
/
ALTER TABLE YOUR_TABLE
 ADD
 UNIQUE
 ( duplicate_field(s)
 )
 EXCEPTIONS INTO EXCEPTION
/
After this manipulation you'll have table exception with rowids of duplicate records.

--
Have a nice day
Michel


"Haplo" <Andrzej.Siedy_at_shh.pl> a écrit dans le message news: 9joemu$p81$1_at_news.tpi.pl...


>         Hi Friends...


>

>     I have one big problem. I need to find all duplicate records in two

> tables with circ. 30.000 records, thise tables have 12 & 21 columns. How to

> do it fast. (PL/SQL procedure)

>

> Many thanks !!!

>

>

Received on Thu Jul 26 2001 - 10:23:41 CEST