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: help:delete duplicated records

Re: help:delete duplicated records

From: <pl_sql_plus_at_yahoo.com>
Date: Mon, 09 Oct 2000 23:22:56 +0200
Message-ID: <39E23730.C6E1C86D@yahoo.com>

Hi
i had this problem before,
my example ist

delete from test t1
where t1.id = (select t2.id

                    from test t2
                    where t1.id=t2.id
                    t1.rowid <> t2.rowid);

ciao
akram jaro

sc schrieb:

> I have a table which has about 20,000 duplicated rows. When I was trying to
> delete it using rowid, it takes for ever to finish, finally I have to cancel
> the query. Could somebody tell me how I should do with it? I can not
> enable PK now for the table.
>
> Thank you for you help.
Received on Mon Oct 09 2000 - 16:22:56 CDT

Original text of this message

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