SQL> select replace('abcd xyz',' ','') from dual ;

REPLACE
-------
abcdxyz


Tamil