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,

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 64Bit
Received on Mon Mar 09 2009 - 09:09:56 CDT

Original text of this message