I need a sql query to replace the character (between ascii value 0 to 31) in the string using a null value. For example
select replace('asas
',chr(10),'') from dual;
The problem here is I cannot replace all the characters falling between ascii values 0 - 31.
For ascii values please see the below link:
https://www.techonthenet.com/ascii/chart.php