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;

Source: stackoverflow.com

Similar codes

0 vote177 views1 answer
Get all employees if name ends with in sql
SQL
0 vote183 views1 answer
Sql select min row
SQL
0 vote204 views1 answer
Mysql cli output to a file
SQL
0 vote201 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote154 views1 answer
Oracle function select into
SQL
0 vote204 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
2 votes202 views2 answers
Mysql search for column name in all tables
SQL
0 vote183 views1 answer
Oracle procedure chain step
SQL
13 votes193 views2 answers
Get date from now() mysql
SQL
0 vote197 views1 answer
Set classpath for mysql-connector.jar
SQL