Article View: comp.databases.oracle.misc
Article #24Re: Help - SQL update of character field in table
From: Boi Hue La
Date: Fri, 23 Oct 1998 00:00
Date: Fri, 23 Oct 1998 00:00
29 lines
1604 bytes
1604 bytes
Hi,
Here's the solution:
update tablex set description='Up Miller''s creek' where response=1
(Two characters of ' between r and s).
Regards
Steve Agnew wrote:
> 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:
<3630A0F6.A16B92DC@montreal.radio-canada.ca>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: Boi Hue La <boihuel@montreal.radio-canada.ca> Subject: Re: Help - SQL update of character field in table Date: 1998/10/23 Message-ID: <3630A0F6.A16B92DC@montreal.radio-canada.ca> X-Deja-AN: 404314460 Content-Transfer-Encoding: 7bit References: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net> X-Trace: wagner.videotron.net 909156599 205.151.224.174 (Fri, 23 Oct 1998 11:29:59 EDT) Organization: Radio-Canada X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii MIME-Version: 1.0 NNTP-Posting-Date: Fri, 23 Oct 1998 11:29:59 EDT Newsgroups: comp.databases.oracle.misc,bit.listserv.sqlinfo,comp.databases.oracle.misc X-Complaints-To: abuse@videotron.net