Article View: comp.databases.oracle.misc
Article #23Re: Help - SQL update of character field in table
From: Izabella
Date: Fri, 23 Oct 1998 00:00
Date: Fri, 23 Oct 1998 00:00
22 lines
1376 bytes
1376 bytes
Try using two single quotes (NOT a double quote) when you want to insert a
quote, eg:
update tablex set description='Up Miller''s creek' where ...
Steve Agnew wrote in message
<7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>...
>I'm new to SQL Plus, so I hope this question isn't to stupid...
>
>I would like to know how to update a character field in a table when the
>information being added contains a single-quote.
>
>For example, the following works fine:
> update tablex set description='Up the creek' where response=1
>but
> update tablex set description='Up Miller's creek' where response=1
>comes back with an error.
>
>Is there some way to get around this problem?
>
>I would appreciate any assistance.
>
>Steve
Technical Details
Message-ID:
<70oepp$r5s$1@platinum.sge.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f99a8,c8a602c51b53d138 X-Google-Attributes: gidf99a8,public X-Google-Thread: 11355a,c8a602c51b53d138 X-Google-Attributes: gid11355a,public From: "Izabella" <Izabella.Urbanek@afp.gov.au> Subject: Re: Help - SQL update of character field in table Date: 1998/10/23 Message-ID: <70oepp$r5s$1@platinum.sge.net> X-Deja-AN: 404093578 References: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: SGE Newsgroups: comp.databases.oracle.misc,bit.listserv.sqlinfo,comp.databases.oracle.misc