home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,150 of 2,288   
   .com to andy   
   Re: Control Characters in column   
   26 Feb 04 08:40:00   
   
   From: mcstockX@Xenquery   
      
   "andy"  wrote in message   
   news:475aa3f5.0402260528.446057f8@posting.google.com...   
   | 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.   
      
   use the replace and the chr functions -- if i got the chr code right, this   
   should work, as long as you've got a sufficiently large rollback segment:   
      
   update the60mtable   
   set thebadcolumn = replace(thebadcolumn,chr(2),null)   
   where thebadcolumn like '%'||chr(2)||'%'   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca