DEV Community

Query Filter
Query Filter

Posted on

repl

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;

Top comments (0)