Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

SOUNDEX() returns a character string containing the phonetic representation of a character

SQL> SQL> Syntax: SOUNDEX(<character_string>) SQL> SQL> SQL> SELECT   2     SOUNDEX('OLD TIME')  ENGLISH,   3     SOUNDEX('OLDE TYME') OLD_ENGLISH   4  FROM dual; ENGL OLD_ ---- ---- O433 O433 SQL>