SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace the characters falling under ascii value 1 to 31 to NULL

ora_1978Jul 12 2018 — edited Jul 12 2018

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2018

Added on Jul 12 2018

#sql

11 comments

4,510 views