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

3 votes263 views2 answers
Current year sql
SQL
5 votes245 views2 answers
Oracle to_timestamp
SQL
16 votes263 views4 answers
Mysql import from sql file
SQL
16 votes284 views3 answers
Update table from another table
SQL
0 vote289 views1 answer
How to find sql server installation folder
SQL
24 votes270 views6 answers
Rename a column in sql server
SQL
0 vote256 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote264 views2 answers
Android sqlite query join
SQL
0 vote274 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote270 views1 answer
Mysql export search results
SQL