Re: 0 results found. Did you mean "***"?
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Feb 2008 15:35:46 -0800
Message-ID: <1202859323.265919@bubbleator.drizzle.com>
>
> Well, but how do I find out the fuzzy matches? How do I know that there
> is "oscar" which is similar to "oskar"?
>
> Regards
> Marten
Date: Tue, 12 Feb 2008 15:35:46 -0800
Message-ID: <1202859323.265919@bubbleator.drizzle.com>
Marten Lehmann wrote:
>> Guess you have to compare the number of exact matches to >> the number of fuzzy matches.
>
> Well, but how do I find out the fuzzy matches? How do I know that there
> is "oscar" which is similar to "oskar"?
>
> Regards
> Marten
You are probably referring to SOUNDEX
http://www.psoug.org/reference/string_func.html#sfsd
But also look at Oracle Text and the UTL_MATCH package: http://www.psoug.org/reference/utl_match.html
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Feb 12 2008 - 17:35:46 CST