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

When Asked, just type in &Bread

-Marc

In article <34f62aaf.19559414_at_waubel.wau.mis.ah.nl>,   kaboel_at_wau.mis.ah.nl wrote:
>
> Try this,
>
> chr(38) for & (ampersand) and chr(39) for ' (quote)
>
> On Thu, 19 Feb 1998 18:34:33 +0800, "News" <jeffrey_at_cradle.com.tw>
> wrote:
>
> >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?
> >
>
> Kaboel Karso
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Feb 19 1998 - 00:00:00 CST