Greetings all.
Problem: Have control characters mostly ^B which are loaded into a
table in our database forming part or a narative field. In TOAD these
appear as a thick bar - kind of like a pipe character '|' but thicker.
We need to get rid of these as they are causing problems with our
information exchange software. Does anybody have any idea how to do a
search and replace for such characters in an oracle 9i database? The
table has over 60M record so I dont facy checking it manually as I
recon Ill be 84 years old by the time im finished!
Thanks.
Received on Thu Feb 26 2004 - 07:28:48 CST
