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 votes156 views1 answer
Define REGEXP?
SQL
-1 vote166 views1 answer
Mysql faster insert
SQL
2 votes145 views1 answer
Sql string_agg
SQL
0 vote166 views1 answer
Drop domain postgresql
SQL
0 vote125 views1 answer
Resulting Query
SQL
0 vote129 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote148 views1 answer
Get relation data in mysql using query to excel
SQL
2 votes177 views1 answer
Sql compare strings
SQL
34 votes168 views6 answers
Alter table add foreign key mysql
SQL
1 vote156 views1 answer
Postgres power
SQL