Re: Help with "&"

From: Leonid Lamburt <ll01_at_gte.com>
Date: 1997/12/11
Message-ID: <01bd0672$b64a1a30$0d87c584@buggs>#1/1

How about this:
set escape on
select 'bla bla \& bla' from dual;
set escape off

Rockhead33 <rockhead33_at_aol.com> wrote in article <19971210173701.MAA15413_at_ladder01.news.aol.com>...
> We are trying to do a simple update in a field.
> UPDATE tablename set fileldname = "blah"
> where fieldname = "blah blew & etal"
>
> It is returning a prompt to enter in a string for etal.
> Is & a wildcard or something else in Oracle? Do I need a litoral symbol
of
> some kind?
> I dont have much more info than that. And I do not know oracle. Sorry.
> Thanks in advance
>
Received on Thu Dec 11 1997 - 00:00:00 CST