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

1 vote209 views1 answer
Mysqli connect
SQL
0 vote229 views1 answer
Sql developer connect to sql server
SQL
0 vote303 views2 answers
Mysql insert rows to another database
SQL
0 vote215 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote239 views1 answer
Oracle query to find schema you are working on
SQL
1 vote230 views1 answer
Raw query must include primary key
SQL
1 vote243 views1 answer
Add many column to sap iq table
SQL
0 vote237 views1 answer
Mysql server not starting in xampp in mac
SQL
3 votes217 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
3 votes212 views1 answer
Oracle undo tablespace list by user
SQL