Learn how to use the Oracle/PLSQL SOUNDEX function with syntax and examples.
The Oracle/PLSQL SOUNDEX function returns a phonetic representation (the way it sounds) of a string.
The syntax for the Oracle/PLSQL SOUNDEX function is:
SOUNDEX( string1 )
string1 is the string whose phonetic value will be returned.
The SOUNDEX function algorithm is as follows:
The SOUNDEX function can be used in the following versions of Oracle/PLSQL:
Let's look at some Oracle SOUNDEX function examples and explore how to use the SOUNDEX function in Oracle/PLSQL.
SOUNDEX('tech on the net') Result: 'T253' SOUNDEX('TECH ON THE NET') Result: 'T253' SOUNDEX('apples') Result: 'A142' SOUNDEX('apples are great') Result: 'A142' SOUNDEX('applus') Result: 'A142'