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: 270
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: Tue Feb 11 08:37:50 CST 2025