oracle remove line breaks

Solutions on MaxInterview for oracle remove line breaks by the best coders in the world

showing results for - "oracle remove line breaks"
Aaliyah
09 Jan 2019
1-- Removes line breaks
2DECLARE
3    teststring VARCHAR2(32767) := ' This is the value
4
5that I chose';
6BEGIN
7    DBMS_OUTPUT.PUT_LINE(teststring);
8    DBMS_OUTPUT.PUT_LINE(replace(replace(teststring, chr(13), ''), chr(10), ' '));
9END;