SOUNDEX() returns a character string containing the phonetic representation of a character : SOUNDEX « Char Functions « Oracle PL / SQL

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

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>

 

Related examples in the same category