Re: How to find non printable characters in a column using regexp

If you are on 10.2 (you didn't say) - take a look at the perl extensions to
oracle's regular expressions. Namely the \W operator (non-word).

Stefan

On 4/13/07, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:

I am trying to find the records where there are non printable characters,
i am not having success with it


select
* from njcrc .tblprogram where REGEXP_INSTR(description,'[[:cntrl:]]') >0;



Above sql pulls records where there are no "non printable" characters.

Can any point me to an alternate way achieving this or let me know what am
i doing wrong.



Thanks

Deen




--
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com

=========================

Other related posts: