On Nov 18, 12:41 pm, "shakespeare" <what..._at_xs4all.nl> wrote:
> "Rosh157" <kouroshs..._at_gmail.com> schreef in berichtnews:019d16d3-1185-4389-aeb5-272ec87715c0_at_s12g2000prg.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.
> > This is a select statement from service:
> > SQL> select * from service;
>
> > SERVICE DESCRIPTION
> > UNITPRICE
> > ---------- --------------------------------------------------
> > ----------
> > 10 Mens Shirt
> > 1.5
> > 11 Dress Shirt
> > 2.5
> > 15 Women Shirt
> > 1.5
> > 16 Blouse
> > 3.5
> > 17 Dress
> > 4.5
> > 20 Slacks-Men
> > 5
> > 25 Slacks-Women
> > 6
> > 30 Skirt
> > 5
> > 31 Dress Skirt
> > 6
> > 40 Suite-Men
> > 9
> > 45 Suite-Women
> > 8.5
>
> > SERVICE DESCRIPTION
> > UNITPRICE
> > ---------- --------------------------------------------------
> > ----------
> > 50 Tuxedo
> > 10
> > 60 Formal Gown
> > 10
>
> > 13 rows selected.
> > and i using Sql*Plus on oracle.
> > i would Thanks a lot if some one can help me with this.
> > Thanks.
>
> There's a quote in Men's shirt closing your string. That's the problem.
>
> Shakespeare- Hide quoted text -
>
> - Show quoted text -
Yes i knew that's a problem ,and i can't and i don't know how to do it
because i have to change that to"Men's Shirt"
and show it in the table.
Received on Sun Nov 18 2007 - 15:56:12 CST
