Re: Update Table

Rosh157 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:
>
>> 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.i have to show the
> "Men's Shirt" in the Table.
> is it possibole or not.
> any help
> Thanks a lot.

Sure, just repeat the single quote within the string. You first should decide however what your string should look like exactly, as you have managed in your short question to change it in Mens' Shirt first, then in Mens's Shirt and finally in Men's Shirt ...

HTH

-- 
Jeroen