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
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.
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: 65084
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.

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

Current Time: Sat Jul 22 17:54:58 CDT 2017

Total time taken to generate the page: 0.09361 seconds