Remove whitespaces/blanks from a string

[jmodic]

SQL> SELECT REPLACE('Tom Hanks' , ', ', ',') FROM dual;

REPLACE('
---------
Tom Hanks

SQL> SELECT REPLACE('Tom, Hanks' , ', ', ',') FROM dual;

REPLACE('
---------
Tom,Hanks

SQL>