UPDATE my_table
SET my_clob_column =
REPLACE(
REPLACE(
REPLACE(my_clob_column, 'EOLN13', CHR(13)),
'EOLN10', CHR(10)
),
'EOLN160', CHR(160)
)
WHERE my_clob_column LIKE '%EOLN%';
COMMIT;
UPDATE my_table
SET my_clob_column =
REPLACE(
REPLACE(
REPLACE(my_clob_column, 'EOLN13', CHR(13)),
'EOLN10', CHR(10)
),
'EOLN160', CHR(160)
)
WHERE my_clob_column LIKE '%EOLN%';
COMMIT;
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)