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

3 votes175 views1 answer
Créer une table sql
SQL
0 vote173 views1 answer
Sql select by content lenght
SQL
2 votes171 views1 answer
Sql like variable
SQL
0 vote170 views1 answer
ORACLE PARSE STRING
SQL
2 votes170 views1 answer
Oracle kill session by sql_id
SQL
0 vote190 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote191 views1 answer
Mysql url
SQL
2 votes169 views1 answer
Oracle trace file
SQL
1 vote167 views1 answer
Oracle apex prevent initial load
SQL
0 vote163 views4 answers
How to drop all tables in sql
SQL