SQL select and Oracle software

From: Dave Angalich <dangalich_at_nttc.edu>
Date: 1998/01/16
Message-ID: <34BFD6E0.AA3E7955_at_nttc.edu>#1/1


[Quoted] [Quoted] We have recently combined 10+ different client databases into 1 large database. This along with CSR entry has led to duplicate/erroneous records. What I need to do is find a good way/tool to list and remove the possible duplicates and update the necessary key/foreign key ingo.(ex. List all people with the same last and first names and city and pick which ones are dups. The picking can be manual.)

Does anybody know of such a tool?? If not can you think of an efficient [Quoted] way in SQL to list these dups?

Thanks in advance,
Dave Angalich Received on Fri Jan 16 1998 - 00:00:00 CET

Original text of this message