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 votes135 views1 answer
Sql view column data type
SQL
0 vote195 views1 answer
Create table database in psql
SQL
0 vote191 views1 answer
Bigquery declare
SQL
0 vote196 views2 answers
How to use aggregate functions in sql
SQL
0 vote192 views4 answers
Mysql on kubernetes
SQL
0 vote218 views1 answer
Ubuntu connect to mssql database
SQL
20 votes192 views5 answers
Mysql reset auto increment to 1
SQL
0 vote183 views1 answer
How to start my sql server on mac
SQL
0 vote182 views1 answer
Mysql case when null
SQL
19 votes196 views3 answers
How to change column type psql
SQL