Re: Convert RTF to Text in Oracle 9i DB columns

Alison wrote:

> I have been tasked to convert all the RTF data in the oracle tables to text.
> I can not find a simple way to do this..
>
> Any ideas???
>
> Thanks Alley

With apologies:

UPDATE table
SET column = 'RTF' || 'M;
WHERE column = 'RTF';

Sorry ... I just couldn't resist. I tried ... I really tried.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)