 |
| Oracle:: How to remove New Line characters and Tab's in the SQL output |
a bit explanation from prasad22cm :
If the data in your database is POSTED from HTML form TextArea controls, different browsers use different New Line characters:
Firefox separates lines with CHR(10) only
Internet Explorer separates lines with CHR(13) + CHR(10)
Apple (pre-OSX) separates lines with CHR(13) only
So, we can conclude that to remove the new line, there were 3 CHR's type that we had to remove. . . .
and to remove 3rd of the new line types, you may need this syntax :
select REPLACE(REPLACE(REPLACE(your_char, CHR(10)), CHR(13)), CHR(9)) from your_table;
