Mladen Gogala wrote:
> On Wed, 13 Dec 2006 09:31:41 -0800, lalit wrote:
>
>> hey guys ,,
>> i m new to oracle and i m having a problem...
>> how can i find out duplicate tuples and then delete them....
>> plz reply.......
>
> One way would be to truncate the table. That will get 'em, nasty tuples.
> That's something that Tom Kyte did not think about. For more practical
> solution, enter "duplicate records" in the search engine on
> http://asktom.oracle.com.
> I dare say, though, that my solution will outperform Tom's.
I'll bet DROP TABLE will too. <g>
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Dec 17 2006 - 15:46:59 CST
