Soundex: converts a string to a code value : SOUNDEX « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. SOUNDEX

Soundex: converts a string to a code value


SQL> -- Soundex: converts a string to a code value.
SQL>
SQL> --Words with similar sounds will have a similar code value, so you can use SOUNDEX to compare words --that are spelled slightly differently but sound basically the same.
SQL> -- SOUNDEX(string)
SQL> SELECT SOUNDEX('Time') FROM dual;

SOUN
----
T500








Related examples in the same category

1.SOUNDEX() returns a character string containing the phonetic representation of a character
2.SOUNDEX('Lari')
3.SOUNDEX('whyte')