what is that &&?

[wwalice]

Hi,
Now i have a table emp (name varchar2(200)).
I inserted data as below:

insert into emp values ( 'tony & stone');

i was prompted:
enter value for stone:

I know that because of the "&" in the statement. I really want it in the table. So how could i disable the meaning of "&"?
I used \& to try. It failed.

Any ideas?

[sysdba]

Under sql*plus, type:
set scan off, then insert stmt with only one '&'

[Felix]

Hi,

use set escape charater before the &
more easy.

Ok.

[Bhaskara]

Try this one.

set define ?
insert into emp values ( 'tony & stone');

Thanks,
Bhaskar

[Prof]

Perhaps
set define off