similarity of names
From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Mon, 9 Mar 2009 15:09:56 +0100
Message-ID: <148ozfys87px0$.im04xyjx2nv4.dlg_at_40tude.net>
Hi,
Date: Mon, 9 Mar 2009 15:09:56 +0100
Message-ID: <148ozfys87px0$.im04xyjx2nv4.dlg_at_40tude.net>
Hi,
we are using this construct
replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace( lower(ANY_NAME), ' ',''),',',''),'ä','a'),'ü','u'),'ö','o'),'ß','s'),'oe','o' ),'ue','u' ),'ae','a'), 'y','i'),'ll','l'),'nn','n'),'ss','s')
for comparing a given person-name with our database-person-names
is there a better solution or are the multiple replaces fast enough.
In my programms I iterate char by char and substitute using fast
case-constructs for substitution.
But I don't know how fast a char-by-char-solution in a PL/SQL-function
would be.
-- Norbert Oracle9i Enterprise Edition Release 9.2.0.8.0 64BitReceived on Mon Mar 09 2009 - 09:09:56 CDT