Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Update Table
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
![]() |
![]() |