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

2 votes124 views1 answer
Guid to string sql
SQL
0 vote120 views1 answer
Sql get year from datetime field
SQL
1 vote127 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote133 views1 answer
Datagrip execute procedure
SQL
1 vote120 views1 answer
Mysql list bigger table
SQL
-1 vote128 views1 answer
Can pandas fetch data from sql
SQL
0 vote119 views1 answer
How to add boolean column in postgresql
SQL
9 votes117 views1 answer
No sql
SQL
0 vote112 views1 answer
Create new schema mysql
SQL
0 vote150 views2 answers
How to get max from each department in sql
SQL