Fuzzy search [message #279164] |
Wed, 07 November 2007 03:16 |
mpls51
Messages: 2 Registered: November 2007
|
Junior Member |
|
|
I have the following two tables
smc_book table:
smc_id smc_title smc_publisher smc_release_date
------------------------------------------------------------------------------------------------------------------------------------- --------
1234 "Beautiful Wonder" "Wrox Books" 1/1/1999
2356 "Master PL/SQL" "OReilly Media" 6/5/2004
5432 "Harry Potter and Goblet of Fire" "Simon & Shuster" 2/4/2001
arc_book table:
arc_id arc_title arc_publisher arc_release_date
------------------------------------------------------------------------------------------------------------------------------------- --------
1245 "Wonder, Beautiful" "Wrox" 1/1/1999
1244 "The PL-SQL, Master (RE 1983)" "Media, OReilly" 6/5/2004
4352 "Golbet of Fire, Harry Potter" "Simon and Shuster" 2/4/2001
I want to match up records between the two tables that have similar titles. So, the following would be matches
smc_id arc_id
-----------------------
1234 1245
2356 1244
5432 4352
i.e. The title "Beautiful Wonder" in smc_book table would match up with "Wonder, Beautiful" in arc_book, etc...
How would this be done in oracle.
|
|
|