Oracle remove double / multiple spaces By admin Posted on July 11, 2014 Posted in Oracle Tagged with oracle, regex, regexp SELECT TRIM(REGEXP_REPLACE(<str>,’ +’,’ ‘)) AS compressed_str FROM <TABLE>