hi, good afternoon, you can try something like this>


select replace('test of removing blanks padded between a string',' ',null) from dual