SOUNDEX
Syntax
Purpose
SOUNDEX returns a character string containing the phonetic representation of
char. This function allows you to compare words that are spelled
differently, but sound alike in English.
The phonetic representation is defined in The Art of Computer Programming,
Volume 3: Sorting and Searching, by Donald E. Knuth, as follows:
Retain the first letter of the string and remove all other occurrences of
the following letters: a, e, h, i, o, u, w, y.
Assign numbers to the remaining letters (after the first) as follows:
b, f, p, v = 1
c, g, j, k, q, s, x, z = 2
d, t = 3
l = 4
m, n = 5
r = 6
If two or more letters with the same number were adjacent in the original
name (before step 1), or adjacent except for any intervening h and w, omit
all but the first.
Return the first four bytes padded with 0.
Example
SELECT ename
FROM emp
WHERE SOUNDEX(ename)
= SOUNDEX('SMYTHE');
ENAME
----------
SMITH
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com <mailto:[Email Address Removed]
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
-----Original Message-----
From: L [mailto:[Email Address Removed] Friday, August 31, 2001 1:58 PM
To: LazyDBA.com Discussion
Subject: [Q] anyone know where has soundex routen?
We are forced to use "soundex" to make primary key. Does anyone know
ORACLE provide 'soundex' as PL/SQL package or function? If NOT where can
I find that information?
Thanks
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you
Oracle LazyDBA home page