Re: Help - SQL update of character field in table - Article 25 - go-pugleaf

Article View: comp.databases.oracle.misc

Article #25

Back to comp.databases.oracle.misc Previous Next

Re: Help - SQL update of character field in table

#25

From: Steve Agnew
Date: Sat, 24 Oct 1998 00:00

31 lines
1514 bytes

Problem solved......

Thanks to all who responded by email and in the group.
Using 2 single quotes '' worked.

Steve


In article <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>, 
agnews@inforamp.net says...
>
>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: <AXbY1.119$Z.559981@NewsRead.Toronto.iSTAR.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <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: agnews@inforamp.net (Steve Agnew)
Subject: Re: Help - SQL update of character field in table
Date: 1998/10/24
Message-ID: <AXbY1.119$Z.559981@NewsRead.Toronto.iSTAR.net>
X-Deja-AN: 404504269
References: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>
Content-Type: Text/Plain; charset=US-ASCII
X-Trace: NewsRead.Toronto.iSTAR.net 909200224 137.186.225.53 (Fri, 23 Oct 1998 23:37:04 EDT)
MIME-Version: 1.0
NNTP-Posting-Date: Fri, 23 Oct 1998 23:37:04 EDT
Newsgroups: comp.databases.oracle.misc,bit.listserv.sqlinfo,comp.databases.oracle.misc

Reply to Parent Message