Posted By

bbrumm on 02/15/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/15/17 05:20am

Statistics

Viewed 743 times

Favorited by 0 user(s)

Related snippets

Oracle SOUNDEX Function

/ Published in: SQL

A few examples of the SOUNDEX function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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');