Oracle / PLSQL: SOUNDEX Function

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'