Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. SOUNDEX() returns a character string containing the phonetic representation of a character
SQL>
SQL>
Syntax: SOUNDEX()
SQL>
SQL>
SQL> SELECT
  2     SOUNDEX('OLD TIME')  ENGLISH,
  3     SOUNDEX('OLDE TYME') OLD_ENGLISH
  4  FROM dual;
ENGL OLD_
---- ----
O433 O433
SQL>