This article is written about how to use the Oracle/PLSQL SOUNDEX feature with syntax and examples.
Description
The Oracle/PLSQL SOUNDEX function returns a phonetic illustration (the way it sounds) of a string.
Syntax
The syntax for the SOUNDEX function in Oracle/PLSQL is:
SOUNDEX( string1 )Parameters or Arguments
string1 The string whose phonetic price will be returned.
Returns
The SOUNDEX function returns a string value.
Note
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.
Applies To
The SOUNDEX feature can be used in the following variations of Oracle/PLSQL:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example
Let’s appear at some Oracle SOUNDEX characteristic examples and explore how to use the SOUNDEX characteristic in Oracle/PLSQL.
For example:
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'