Re: Update is not working

> Hi friends,
> I am in trouble to do the following update:
>
> update eri set texto = 'CONDUTOD MC'S 12234' ;
>
> How can I do it ?

You need to escape the apostrophe (single-quote) in the text. One way to do this is simply double it:

update eri set texto = 'CONDUTOD MC''S 12234' ;

Another is to use the "q" alternative quoting mechanism:

update eri set texto = q'[CONDUTOD MC'S 12234]' ;

Both are described in the Oracle docs. GL!

Rich

--
http://www.freelists.org/webpage/oracle-l