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

From: Kaboel Karso <kaboel_at_wau.mis.ah.nl>
Date: 1998/02/19
Message-ID: <34f62aaf.19559414@waubel.wau.mis.ah.nl>#1/1

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 Received on Thu Feb 19 1998 - 00:00:00 CST