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

Home -> Community -> Mailing Lists -> Oracle-L -> Script that will remove redundant rows from table

Script that will remove redundant rows from table

From: Haskins, Ed <Ed.Haskins_at_VerizonWireless.com>
Date: Wed, 16 May 2001 17:21:34 -0700
Message-ID: <F001.003059C9.20010516171024@fatcity.com>

A few
months ago I remember seeing a script that enabled the removal of redundant rows in a table.  Can someone please forward or point me to such a script.
<SPAN

class=046355716-14052001> 
I have
an Oracle Names server that stores the database connect descriptors in a table within the Region Database.  I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise.  My problem is that there exists duplicates from the multiple SQLNET.ora files.  I really want to clean this up so that only one entry per connect descriptor exists.  I think that a generic script for any table will work in this situation.
<SPAN

class=046355716-14052001> 
<SPAN

class=046355716-14052001>Thanks,
Ed
Haskins
Oracle
DBAVerizon Wireless Received on Wed May 16 2001 - 19:21:34 CDT

Original text of this message

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