Re: Update Table

From: Ruud de Koter <nobody_at_internet.org>
Date: Sun, 18 Nov 2007 23:02:45 +0100
Message-ID: <4740b678$0$239$e4fe514c@news.xs4all.nl>

Hi Rosh157,

> On Nov 18, 12:41 pm, "shakespeare" <what..._at_xs4all.nl> wrote:

>>
>>
>>> Hi every one:
>>> i'm kind of new in Sql*plus and Oracle and i have some problem in
>>> Update the value in one of the table.I want a Write an UPDATE
>>> statement to change values of SERVICE.Description from, Mens Shirt to,
>>> Mens' Shirt. when i try to do that the error show me that:
>>> SQL> UPDATE Table Service
>>> 2 SET Description='Mens's Shirt'
>>> 3 WHERE Deccription='Mens Shirt';
>>> ERROR:
>>> ORA-01756: quoted string not properly terminated
>>> I don't know how i have to close the quoted string.

>> There's a quote in Men's shirt closing your string. That's the problem.
>>
>> Shakespeare- Hide quoted text -
>>
>> - Show quoted text -

> 
> Yes i knew that's a problem ,and i can't and i don't know how to do it
> because i have to change that to"Men's Shirt"
> and show it in the table.

You should escape the quote using the quote character. So your update string would be 'Men''s Shirt' instead of 'Men's Shirt'.

Regards,

Ruud de Koter. Received on Sun Nov 18 2007 - 16:02:45 CST