Control/Garbish characters data scrubbing

From: Lu Kai Hin <lukh_at_hhb.com.my>
Date: Tue, 21 Nov 2000 23:02:46 +0800
Message-Id: <10687.122611@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C0540F.2963C1A0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Listers,

Anyone have any SQL*Plus or PL/SQL scripts to scan a table (all columns = and all rows) for control/garbish characters, and scrub them?

Thanks in advance.
James

------=_NextPart_000_0017_01C0540F.2963C1A0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Listers,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Anyone have any SQL*Plus or PL/SQL =
scripts to scan=20
a table (all columns and all rows) for control/garbish characters, and = scrub=20
them?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>James</FONT></DIV></BODY></HTML>

------=_NextPart_000_0017_01C0540F.2963C1A0-- Received on Tue Nov 21 2000 - 09:02:46 CST