By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
dbms_output:
TO_CHAR(t.F_M_ID) AS F_M_ID, t.FOO, REPLACE(REPLACE(t.BAR, CHR(13), ''), CHR(10), '') AS BAR
1 rows affected
dbms_output:
TO_CHAR(t.F_M_ID) AS F_M_ID, t.FOO, REPLACE(REPLACE(t.BAR, CHR(13), ''), CHR(10), '') AS BAR