Home » SQL & PL/SQL » SQL & PL/SQL » Alternative Of Soundex Function (Oracle 10g)
Alternative Of Soundex Function [message #443684] Tue, 16 February 2010 23:42 Go to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Dear All,
Is there any alternative of Soundex function. I have two table of city. I want to compare city of both table. Now problem is that one city name is 'HANGO'. In table A City is feeded with spelling 'HANGO' and other it is spelled 'HANGU' OR 'HUNGU'. Similarly there are many cases. I used Soundex functon but it is not working perfectly.

Is there any other way to compare data by sound.

Thanks in advance.

Best Regards.
Asif.
Re: Alternative Of Soundex Function [message #443690 is a reply to message #443684] Wed, 17 February 2010 00:18 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is no other Oracle built-in function but you can find on the web many similar functions and maybe one will fit your needs but you have to ask "how can I kow that 'HANGO', 'HANGU' and 'HUNGU' are identical", if youi can't yourself answer this question you wsill not be able to choose among the functions you will find.

Regards
Michel
Previous Topic: How to find a remote dependencies of a database object
Next Topic: Sending PDF through mail (merged 3)
Goto Forum:
  


Current Time: Mon Sep 26 16:11:34 CDT 2016

Total time taken to generate the page: 0.12191 seconds