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 votes222 views1 answer
Mysql now format
SQL
0 vote204 views1 answer
Drop index in sql
SQL
0 vote205 views2 answers
Plsql function that return a table
SQL
1 vote192 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote216 views1 answer
Mysql limit order by
SQL
0 vote213 views1 answer
Sql get date from timestamp
SQL
0 vote199 views1 answer
Alter owner in PostgreSQL
SQL
4 votes175 views1 answer
Install postgres 12 on ubuntu
SQL
11 votes196 views4 answers
Query DISTINCT
SQL
0 vote221 views1 answer
Providername system.data. mysql
SQL