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!

How to replace non printable characters from a varchar2 field in Oracle 9i?

796997Sep 18 2010 — edited Sep 18 2010

Hi Friends,

Can you help me to find a sql query to replace/remove non printable characters from a varchar2 field in Oracle 91 database.

I have the following syntax is hand which is working only in Oracle 10G:

regexp_replace(varchar2fieldname,'[^[:print:]]')

The syntax REPLACE(FIELD_NAME,CHR(10),'') is also not working.

Thanking you,

Franklin.K.F

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2010

Added on Sep 18 2010

#pl-sql

2 comments

12,470 views