Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how do I insert O'Hare value ? ie how do I escape the apostrophe
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