Re: Help with "&"

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