Answers for "oracle remove line breaks"

SQL
0

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;
Posted by: Guest on March-15-2021

Code answers related to "oracle remove line breaks"

Code answers related to "SQL"

Browse Popular Code Answers by Language