Re: SQL/SQL*Plus Question

From: Actiris <actiris_at_cscoms.com>
Date: Wed, 28 Mar 2001 10:12:28 +0700
Message-ID: <99rl36$gp5$1@news.loxinfo.co.th>

just insert a second apostrophe like:
set name = 'Burt''s Taco Palace'

that will do
beach

--
+++
Beat Christen       chbeach_at_loxinfo.co.th
Phuket/Thailand
+++


"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 - 21:12:28 CST