Oracle drops line breaks in data to avoid problems with reading _oracle

After a lot of data is stored in the database, you may need to remove the entire piece of data and separate it with special symbols, and the entire data must be in one row, so if the data appears
When the line is wrapped, there is a problem reading.

This time you need to do a special processing of the data to be taken out, namely
To remove the newline symbol in it:

Replace (replace (COLUMNNAME,CHR), ""), CHR (13), "")

Add:
Special symbol ASCII definition
Box Drawings Chr (9)
Line feed Chr (10)
return character Chr (13)