• REGEXP_REPLACE
  Oracle replaces each occurrence of two or more spaces with a single space.
  in Oracle > DB 11g with oracle regexp_replace replaces single

replaces from all users