Advanced Search

Return to Snippet

Revision: 71301
at February 15, 2017 05:20 by bbrumm
Initial Code 
--SOUNDEX

--Example 1
SELECT SOUNDEX('Complete') AS testval
FROM dual;

--Example 2
SELECT SOUNDEX('complete') AS testval
FROM dual;


--Example 3
SELECT SOUNDEX('Canne'),
SOUNDEX('Can')
FROM dual;


--Example 4
SELECT first_name, last_name
FROM student
WHERE SOUNDEX(last_name) = SOUNDEX('Smyth');
Initial URL 
http://www.databasestar.com/oracle-soundex/
Initial Description 
A few examples of the SOUNDEX function.
Initial Title 
Oracle SOUNDEX Function
Initial Tags 
sql, Oracle
Initial Language 
SQL