Re: SQL/SQL*Plus Question

set name = 'Burt''s Taco Palace'

HTH, mike

Ryan Hare wrote in message <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 - 17:34:21 CST