Re: SQL/SQL*Plus Question

From: Mike Moore <hicamel_at_mail.home.com>
Date: Wed, 28 Mar 2001 01:48:31 GMT
Message-ID: <Ppbw6.1136$ea6.218895@news1.frmt1.sfba.home.com>

set name = 'Burt''s Taco Palace'

two small quotes should get the desired result

Ryan Hare <rhare_at_fhcrc.org> wrote in message news:3AC11D6F.4A904199_at_fhcrc.org...
>
> I know there should be a simple and obvious answer to this, but for the
> moment it's driving me a bit batty. I need to update an Oracle table
> with a field that contains an apostrophe, something like:
>
> update table.tmp_bad_restaurants
> set name = 'Burt's Taco Palace'
> where restid = 567;
>
> Of course SQl*Plus will choke on the apostrophe as I've written it. I
> know there must be comething that will force a literal string in Oracle,
> but I can't remember it and I'm not finding it in the documentation I
> have.
>
> Someone, please, nudge my memory.
>
> Ryan
Received on Tue Mar 27 2001 - 19:48:31 CST