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 vote240 views1 answer
My sql data file extention
SQL
0 vote289 views1 answer
Sql query to select even numbers
SQL
1 vote243 views1 answer
Use of now() in mysql
SQL
0 vote264 views1 answer
Java sql timestamp now
SQL
0 vote235 views2 answers
Sql drop view if exists
SQL
0 vote237 views1 answer
Sqlite higher or equal
SQL
0 vote216 views8 answers
Convert sql query to linq online
SQL
0 vote237 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote267 views2 answers
How to install psql in ubuntu
SQL
0 vote227 views1 answer
Get foreign table names mysql
SQL