RE: Update is not working

From: Kenneth Naim <kennethnaim_at_gmail.com>
Date: Mon, 16 Jan 2012 12:48:54 -0500
Message-ID: <02bd01ccd477$1e2527d0$5a6f7770$_at_gmail.com>

You need to replace the singe quote with two single quotes.

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eriovaldo Andrietta
Sent: Monday, January 16, 2012 12:41 PM
To: ORACLE-L
Subject: 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 ?

Regards

Eriovaldo

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 16 2012 - 11:48:54 CST