tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

Oracle/PLSQL: SOUNDEX Function

Learn how to use the Oracle/PLSQL SOUNDEX function with syntax and examples.

Description

The Oracle/PLSQL SOUNDEX function returns a phonetic representation (the way it sounds) of a string.

Syntax

The syntax for the Oracle/PLSQL SOUNDEX function is:

SOUNDEX( string1 )

Parameters or Arguments

string1 is the string whose phonetic value will be returned.

Note

The SOUNDEX function algorithm is as follows:

  1. The SOUNDEX function return value will always begin with the first letter of string1.
  2. The SOUNDEX function uses only the first 5 consonants to determine the NUMERIC portion of the return value, except if the first letter of string1 is a vowel.
  3. The SOUNDEX function is not case-sensitive. What this means is that both uppercase and lowercase characters will generate the same SOUNDEX function return value.
Share this page:

Applies To

The SOUNDEX function can be used in the following versions of Oracle/PLSQL:

  • Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example

Let's look at some Oracle SOUNDEX function examples and explore how to use the SOUNDEX function in Oracle/PLSQL.

For example:

SOUNDEX('tech on the net'); would return 'T253'
SOUNDEX('TECH ON THE NET'); would return 'T253'
SOUNDEX('apples'); would return 'A142'
SOUNDEX('apples are great'); would return 'A142'
SOUNDEX('applus'); would return 'A142'