Re: Translation for Oracle?

Thanks bro..
I guess theres no easy way out of this hey ;)

On Nov 29, 5:48 pm, "Mark D Powell" <Mark.Pow..._at_eds.com> wrote:
> On Nov 29, 5:33 am, "RJ" <ridwan.je..._at_gmail.com> wrote:
>
> > Hi All,
>
> > Is there a way to translate words in a column from Afrikaans to
> > English?
> > If not, is there a way to check spelling? If so could I separate
> > misspelled words and insert them in another table (temp table)?
> > I am using 9i and 10g?
>
> > Thanks in advance..RJ, what you seem to be asking for is a translation program. I am sure
> that translation programs have been written, but where to find one that
> would meet your specific needs is another question.
>
> You can do what you want using an update statement and a user function
> that takes the value of the current column and compares it to a
> translation table to get the translated value. Depending on exactly
> what kind and how much translation you need to do writing your own may
> be practical or you may need to look for a commercial product.
>
> HTH -- Mark D Powell --
Received on Thu Nov 30 2006 - 01:47:44 CST