RE: Update is not working

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Mon, 16 Jan 2012 17:53:57 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C5833A68B_at_ICATEXCH1.ICAT.com>

Another way...use the ASCII value for a single quote and concatenate that....

update eri set texto = 'CONDUTOD MC' || chr(39) || 'S 12234';

-joe

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kenneth Naim Sent: Monday, January 16, 2012 10:49 AM
To: ecandrietta_at_gmail.com; 'ORACLE-L' Subject: RE: Update is not working

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

Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--

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