How to remove extra space in between a string? oracle 10g

SQL> select replace('AAA BBB CCC', chr(32), '') from dual;

REPLACE('
---------
AAABBBCCC

source : https://community.oracle.com/thread/1071627