Oracle carriage return, line feed

Return line break

Chr (10) is a newline character,
Chr (13) is the carriage return,

Add line break

Select '  '| | ||       ' Set valid_state = "' 0A "' ; ' || Chr| |  ' commit; '   from User_tables

Remove line breaks

Select ID,replace(Content,to_char (CHR)| | To_char (CHR),'_r_n'from theorder by content;

Remove line breaks, carriage returns, tab summaries from text in Oracle

I. Special symbol ASCII definition

Box Drawings Chr (9)
NewLine character Chr (10)
Carriage return Chr (13)

Second, nested use Repalce, note that only one symbol can be submitted at a time, such as first return and then line

Select REPLACE (GG, CHR, ') ' from dual

Pay attention to Chr (13) | | Chr (10) This kind of combination uses more cases,

The carriage return line in the Notepad is more attractive, so consider this situation.

Select Translate (STRING,CHR)| | Chr (ten),',' from dual;

Third, for the character of large objects of the symbolic processing

For symbolic processing in the Clob field, first To_char and then the same processing

Select to_char (VCL),replace(To_char (VCL), CHR,'[]'   from test_1;

Oracle carriage return, line feed