Oracle Remove line breaks from data to avoid reading problems

After a lot of data is stored in the database, it may be necessary to take out the whole data and divide it with special symbols, and the whole data must be in 1 row, so if the data appears,
In the case of new lines, there is a problem when reading.

At this time, it is necessary to do special processing for the data to be taken out, that is,
Remove the line break symbol inside:

replace(replace(columnName,CHR(10),''),chr(13),'')

Additional:
Special symbol ascii definition
Tab Character chr (9)
Line break chr (10)
Carriage Return chr (13)