Stripping non-printable characters from varchar2 column
Posted on 2004-09-03
I am storing all the sql generated by Informatica PowerMart ETL tool and the sql is being stored with chr(10) and chr(13) in it causing ugly viewing. I'd like to strip that out for easy viewing.
Here is an example:
SELECT DISTINCT HRA_QUESTIONNAIRE.HEALTH_RELATED_ACTIVITY_ID
I've reviewed some of the other answers related to this topic and having found what I need or am not understanding how it works. Can somebody show me how to strip those two characters, maybe replacing them with spaces, and leave the rest of the text?