Re: Help! Deleting duplicate rows

From: Ben Ryan <benryan_at_my-deja.com>
Date: Wed, 15 Sep 1999 16:10:45 GMT
Message-ID: <7rogdp$kg6$1@nnrp1.deja.com>

In article <7ro8l3$e0m$1_at_nnrp1.deja.com>, sjoshi_at_ingr.com wrote:
> Hello All
> Can someone please tell me how to delete duplicate rows from a table
> in Oracle 8.0.4
>
>

SELECT rowid,* FROM your_table;

DELETE FROM your_table WHERE rowid = value;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 11:10:45 CDT

This message: [ Message body ]
Next message: Ben Ryan: "Re: Temporary Table Space Abuse"
Previous message: binoy: "OraclePR2 process 100% -> System hangs"
In reply to: sjoshi_at_ingr.com: "Help! Deleting duplicate rows"
Next in thread: Dogan Cibiceli: "Re: Help! Deleting duplicate rows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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