RE: Logical duplicates

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 28 Jun 2013 09:33:53 -0400
Message-ID: <00cf01ce7404$22d92370$688b6a50$_at_rsiz.com>

If you really have "paris" and "Paris" you'll have to map case in JL's solution. Likewise handling stray spaces and such.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rajugaru.vij_at_gmail.com
Sent: Friday, June 28, 2013 4:06 AM
To: oracle-l_at_freelists.org
Subject: Logical duplicates

Hi,
I have a table, called travel, with columns (source,destination,distance) this is something like, New york to paris and distance between them.

Logically New York to paris or Paris to New York both are same in distance.

But I have two entries for that, I waant to delete all such records.

Any suggestions?

Thanks
Sent on my BlackBerryR from Vodafone--
http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 28 2013 - 15:33:53 CEST