Soundex converts a string to a code value : SOUNDEX « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. SOUNDEX

Words with similar sounds will have a similar code value.

The general format for this function is: SOUNDEX(string)

SQL>
SQL> SELECT SOUNDEX('Time') FROM dual;

SOUN
----
T500

SQL>








11.17.SOUNDEX
11.17.1.Soundex converts a string to a code value
11.17.2.SOUNDEX(x) get a string containing the phonetic representation of x.