This article is written about how to use the Oracle/PLSQL SOUNDEX feature with syntax and examples.
The Oracle/PLSQL SOUNDEX function returns a phonetic illustration (the way it sounds) of a string.
The syntax for the SOUNDEX function in Oracle/PLSQL is:
SOUNDEX( string1 )
Parameters or Arguments
string1 The string whose phonetic price will be returned.
The SOUNDEX function returns a string value.
The SOUNDEX function algorithm works as follows:
The SOUNDEX characteristic return value will continually start with the first letter of string1. The SOUNDEX characteristic uses solely the first 5 consonants to decide the NUMERIC element of the return value, without if the first letter of string1 is a vowel. The SOUNDEX feature is not case-sensitive. What this capacity is that both uppercase and lowercase characters will generate the same SOUNDEX function return value.
The SOUNDEX feature can be used in the following variations of Oracle/PLSQL:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Let’s appear at some Oracle SOUNDEX characteristic examples and explore how to use the SOUNDEX characteristic 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'