Re: how do I insert O'Hare value ? ie how do I escape the apostrophe

From: Peter J. Schoenster <webmaster_at_rede.com>
Date: Tue, 8 Aug 2000 09:45:10 -0600
Message-Id: <10583.114085@fatcity.com>

On 8 Aug 2000, at 6:46, Carmen Rusu wrote:

> Hi Oracle gurus,
> How do I escape the apostrophe character in an insert statement ?

I asked a somewhat similar quesiton ...

O'Hare

try this:

O''Hare

(double the singe quote)

I come from using mysql and in it I just escape the single quote. I though this would work with Oracle (read it in a doc) .. but perhaps its a parameter I have to set ... doubling the single quote works.

Peter

---

Exercise Your Brain, Read a Book
-- O Crazy Gringo, Ipanema, Brazil Received on Tue Aug 08 2000 - 10:45:10 CDT