oracle remove line breaks
-- Removes line breaks
DECLARE
teststring VARCHAR2(32767) := ' This is the value
that I chose';
BEGIN
DBMS_OUTPUT.PUT_LINE(teststring);
DBMS_OUTPUT.PUT_LINE(replace(replace(teststring, chr(13), ''), chr(10), ' '));
END;