As you've already been told & is a reserved character and in
sqlplus it will alway think that you are using the & to represent
a variable. I do however know of one way to get around this. Put
the & character between single quotes and then concatinate it to
the rest of your string. So for instanse if you are trying to set
ENAME in the EMP table to "Jan & Tom" the syntax would be:
insert into EMP (ENAME) values ('Jan '||'&'||' Tom');
--
Michele Garb garbm_at_iterus.org
SAIC, ITER San Diego Joint Work Site
11025 North Torrey Pines Road, La Jolla, CA 92037
Received on Sat Nov 11 1995 - 00:00:00 CET
