RE: Logical duplicates
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <rajugaru.vij@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 Jun 2013 09:33:53 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of rajugaru.vij@xxxxxxxxx
Sent: Friday, June 28, 2013 4:06 AM
To: oracle-l@xxxxxxxxxxxxx
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--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
