Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help - SQL update of character field in table

Help - SQL update of character field in table

From: Steve Agnew <agnews_at_inforamp.net>
Date: 1998/10/22
Message-ID: <7vOX1.90$sE6.410121@NewsRead.Toronto.iSTAR.net>#1/1

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 Received on Thu Oct 22 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US