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 13:59:07 -0800 (PST)
Message-ID: <49329f27-de42-49d3-9b09-8280a29dcdbe@e23g2000prf.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 have to show the "Men's Shirt" in the Table.
is it possibole or not.
any help
Thanks a lot. Received on Sun Nov 18 2007 - 15:59:07 CST

Original text of this message

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