Remove whitespaces/blanks from a string

[jmodic]

SELECT REPLACE('Ron nie', ' ') FROM dual;