The method of removing carriage return line space in Oracle is detailed _oracle

Remove Line Wrap
Update zhzl_address t set T.add_administration_num=replace (T.ADD_ADMINISTRATION_NUM,CHR (10), "");
Remove return
Update zhzl_address t set T.add_administration_num=replace (T.ADD_ADMINISTRATION_NUM,CHR (13), "");
Remove Space
Update zhzl_address t set T.add_administration_num=trim (T.add_administration_num);
-----------------------------
1. Carriage Return line feed
Chr (10) is a newline character,
Chr (13) is a carriage return,
Increase line breaks
select ' Update ' | | table_name | |
' Set valid_state = ' 0A '; Chr (a) | | ' Commit; '
From User_tables

Remove line breaks
Select Id,replace (Content,to_char (Chr (13)) | | To_char (CHR), ' _r_n ') from Fact_content order by content;

Remove line breaks, carriage returns, tab stops in the text in Oracle
ASCII definition of special symbol
Box Drawings Chr (9)
Line feed Chr (10)
return character Chr (13)
Second, nested use Repalce, note that only one symbol can be submitted at a time, such as first enter and then change lines
Select REPLACE (GG, Chr (), ') from dual
Pay attention to Chr (13) | | Chr (10) The use of such a combination of more cases, carriage return line in Notepad is more good-looking point, so to consider this kind of situation
Select Translate (STRING,CHR (13) | | Chr (a), ', ') from dual;

iii. Symbolic processing of large-character objects
For the symbol processing in the Clob field, first To_char and then the same processing
Sql> Select To_char (VCL), replace (To_char (VCL), Chr (a), ' [] ') from test_1;