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 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
![]() |
![]() |