Home » SQL & PL/SQL » SQL & PL/SQL » Name Matching Algorithim
Name Matching Algorithim [message #39060] Tue, 11 June 2002 03:27 Go to next message
Bhagwan Singh
Messages: 23
Registered: December 2001
Junior Member
Hi,
I want to build a Pl/sql program with name matching features and gives output in terms of percentage match.

for eg:
If my database has the following 3 rows
a) John Barry
b) Beckham John
c) Joseph John Augestine

and I give 'John' as input parameter, I should get percentage wise matching with each of the above rows with soundex criteria taken into care.

Can somebody send me an example code?
Regrads,
Bhagwan Singh

Report message to a moderator

Re: Name Matching Algorithim [message #39068 is a reply to message #39060] Tue, 11 June 2002 13:44 Go to previous message
ron
Messages: 50
Registered: July 1999
Member
select name from table
where name like '%john%';
hope this should solve.

Report message to a moderator

Previous Topic: Constraint tablespace
Next Topic: displaying images from oracle 8i blob in asp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 16:19:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.