L <[EMAIL PROTECTED]>
cc:
Subject: RE: Find an unprintable character inside a column
Just a brief foot-note to this discussion.
The reason I selected the data, rather than attempted an automatic
correction, was that sometimes two words would be separated by
t but...
peter
edinburgh
> -Original Message-
> From: Stephane Faroult [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2003 10:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Find an unprintable character inside a column
>
>
> [EMAIL PROTEC
;
cc:
Subject: Re: Find an unprintable character inside a column
[EMAIL PROTECTED] wrote:
>
> I played with this a bit.
>
> First, I created some test data with one column corrupted with a
> single random character
> of 0-31 replacing a random
See notes, 113827.1, 119426.1, 154880.1. Could be done and done, but
not to solve this particular task -- it would be an overkill. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
[EMAIL PROTECTED] wrote:
Defini
DROP TABLE table_1;
CREATE TABLE table_1(data VARCHAR2(10));
INSERT INTO table_1 VALUES(CHR(1)||'ABC');
INSERT INTO table_1 VALUES('ABC'||CHR(25));
INSERT INTO table_1 VALUES(CHR(25)||'@'||CHR(30));
INSERT INTO table_1 VALUES(CHR(25)||'@'||CHR(31));
INSERT INTO table_1 VALUES('ABC');
COMMIT;
VARIAB
<[EMAIL PROTECTED]> To:Multiple
> Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 10/10/2003 07:09 AM cc:
> Please respond to ORACLE-L Subject:RE: RE:
>
cipients of list ORACLE-L <[EMAIL 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 Regu
ease respond to
> ORACLE-L
>
> To:
> Multiple recipients of
> list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:
> RE: RE: RE: Find an
> unprintable character
> inside a column
>
>
> >
L PROTECTED]>
cc:
Subject: RE: RE: RE: Find an unprintable character inside a column
>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
>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 f
--
exception
when others then
return -1;
end BAD_ASCII;
/
--
> -Original Message-
> From: Prem Khanna J [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 09, 2003 10:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
Peter, i would be interested in that.
can you mail it to me ?
Dias Costa
Robson, Peter wrote:
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the user
Peter, i would be interested in that.
can u mail it to me ?
Jp.
09-10-2003 18:29:33, "Robson, Peter" <[EMAIL PROTECTED]> wrote:
>I have a small PL/SQL piece of code used to detect these things, if anyone
>wants it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pre
Yes, exactly Stephane -
Non-printable characters like this are a proper pest in our environment, to
the extent that I have exception reports running every night looking for
them (cannot trust the users...).
I have a small PL/SQL piece of code used to detect these things, if anyone
wants it.
pete
Steve,
If you are patient, I guess that something like
where dump(problem_column) like '%%'
should more or less answer your question.
HTH
SF
>- --- Original Message --- -
>From: "Steve Main" <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]
15 matches
Mail list logo