Replace 2 spaces by 1 space in all values of a column I need to replace 2 spaces by only 1 space for all entries of 1 column in an Oracle database. I found this and tried it:

SELECT REGEXP_REPLACE('MODEL', '[[:space:]]{2,}', ' ') new_string
FROM ops.TBL_PRODUCT_DEIN_DESIGN;


MODEL is the column name. But it has not replaced the double spaces.

How to use that solution or what could be an alternative?
You don't need to use a regular expression for that. Instead, you could use the replace function in SQL like this:

replace(MODEL, '  ', ' ')


where MODEL is your column, '  ' is the character(s) that you want to replace and ' ' is the character(s) you want to replace with.