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

0 vote308 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote295 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote284 views1 answer
Postgresql conectar
SQL
8 votes283 views2 answers
Mysql query dates between two dates
SQL
1 vote351 views1 answer
STOP message of how many rows affected sql
SQL
0 vote299 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote284 views1 answer
Mysql remove tabs from string
SQL
0 vote301 views1 answer
Regex any word except sql
SQL
0 vote304 views1 answer
Check connections to database postgres
SQL
0 vote309 views1 answer
How to print some string in mysql
SQL