regex - Oracle PL/SQL : remove "space characters" from a string - Stack Overflow
To remove any whitespaces you could use: myValue := replace(replace(replace(replace(replace(replace(myValue, chr(32)), chr(9)), chr(10)), chr(11)), chr(12)), chr(13)); Example: remove all whitespaces in a table: update myTable t set t.myValue = replace(re...