Re: Help with "&"

You can change the substitution variable prefix to any char you choose by:

set define !
where ! is the new prefix.

You can also turn off substitution variables totally by:

set define off

Rick Muffler wrote:
>
> The ampersand is a prefix for a variable in sqlplus. So, it is asking
> you for the value that you want to supply for the variable immediately
> following that ampersand, i.e., 'etal' is the variable.
>
> <<One>> way around it is to simply concatenate the various parts of
> the string you are trying to use:
>
> UPDATE tablename set fieldname = 'blah'
> where fieldname = 'blah blew '||'&'||'etal';
>
> hope that helps,
> Rick
>
> Rockhead33 wrote:
> >
> > 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 Wed Dec 10 1997 - 00:00:00 CST