inserting '&' character
morning folks
does anyone know how to insert the '&' character via SQL plus
without there being a prompt for variables?
i created this test table...
create table x(a varchar2(40));
this causes a prompt to appear in sqlplus when i issue...
insert into x values ('fish & chips');
this dosn't but its a bit messy...
insert into x values ('fish '||'''&'''|| ' chips');
any easy way of switching this prompt off?
kind regards
Satnam