Help - SQL update of character field in table - Article 22 - go-pugleaf

Article View: comp.databases.oracle.misc

Article #22

Back to comp.databases.oracle.misc Previous Next

Help - SQL update of character field in table

#22

From: Steve Agnew
Date: Thu, 22 Oct 1998 00:00

16 lines
1212 bytes

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: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,c8a602c51b53d138,start
X-Google-Attributes: gid11355a,public
X-Google-Thread: f99a8,c8a602c51b53d138,start
X-Google-Attributes: gidf99a8,public
From: agnews@inforamp.net (Steve Agnew)
Subject: Help - SQL update of character field in table
Date: 1998/10/22
Message-ID: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>
X-Deja-AN: 404083007
Content-Type: Text/Plain; charset=US-ASCII
X-Trace: NewsRead.Toronto.iSTAR.net 909096003 137.186.227.147 (Thu, 22 Oct 1998 18:40:03 EDT)
MIME-Version: 1.0
NNTP-Posting-Date: Thu, 22 Oct 1998 18:40:03 EDT
Newsgroups: comp.databases.oracle.misc,bit.listserv.sqlinfo,comp.databases.oracle.misc