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

25 votes339 views6 answers
Change column name mysql
SQL
0 vote345 views1 answer
Get who is hired in february in sql
SQL
1 vote335 views1 answer
Apex select list ORA-20999
SQL
1 vote335 views1 answer
Oracle finding duplicate records
SQL
0 vote335 views1 answer
Check if database exists sql
SQL
0 vote320 views1 answer
Oracle select invalid views
SQL
0 vote355 views1 answer
SQL query to verify the size of the table
SQL
6 votes418 views3 answers
What is where in sql
SQL
0 vote354 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote302 views1 answer
Sql truncate table referencing itself
SQL