Re: How can insert '&' in my string?

You'll want to "set scan off" in order to conduct your insert. Then oracle will ignore your "special character (&)" and allow that to be inserted into the table. Issue the command in sqlplus as follows:

  SQL> set scan off

The run your insert/update statement.

Regards.

Steve

News <jeffrey_at_cradle.com.tw> wrote in article <6ch1t5$n72_at_news.seed.net.tw>...
> Hi, I got a problem, please help me!
> I want to insert a string with '&' into my table, but Oracle always
> recognized the &... as a variable and asked me to input a value... Here's
 my
> trouble...
> create table test ( name varchar2(32) );
> insert into test values ('Butter&Bread');
> then it asked me to input the Bread variable, :(
> How can I tell Oracle I want & to be & but not a variable prefix? I
 tried
> '\&' ,'"&' , '&&', but they didn't work and I can't get information from
 my
> reference book, could someone help me about it? Please! Thanks.
> BTW, how about single quotation mark?
>
>
>
  Received on Fri Feb 20 1998 - 00:00:00 CST