Some people have requested this code, so I thought
you might as well all
have the chance to pick it to bits... Its a
function called BAD_ASCII, and
it hunts out for any ascii characters with an ascii
value of less than 32 in
a specified field. (Acknowledgments to my colleague
Keith Holmes for help
in the WHERE clause in 10g will be nice.
Jared
Stephane Faroult [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/10/2003 07:09 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: RE: Find an unprintable
Stephane Faroult
[EMAIL PROTECTED]
Sent by:
[EMAIL PROTECTED]
10/10/2003 07:09 AM
Please respond to
ORACLE-L
To:
Multiple recipients of
list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:
RE: RE: RE: Find an
unprintable
PROTECTED]
cc:
Subject:RE: RE: RE: Find an unprintable character inside a column
Actually, I was toying with the idea of writing an external
procedure that would allow me to call pcre library
(PCRE=Perl Compatible Regular Expressions) which would be nice,
but then again