Oracle PL/SQL Soundex Function

The Soundex function returns a phonetic representation of a string.

The Soundex Function syntax:

soundex( string )

Example:

select soundex('plsql report') from dual; 

would return 'P424'


select soundex('PLSQL REPORT') from dual;

would return 'P424'


select soundex('connect') from dual;

would return 'C523'