Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Update Table

Update Table

From: Rosh157 <kouroshsaei_at_gmail.com>
Date: Sun, 18 Nov 2007 14:02:11 -0800 (PST)
Message-ID: <1d444d30-bcb3-466b-b04a-c0cb7e74bd32@e6g2000prf.googlegroups.com>


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. i must change the value and show the"Men's Shirt" in the table.is it possibol to do that or not?
Thanks a lot. Received on Sun Nov 18 2007 - 16:02:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US