How can insert '&' in my string?

From: News <jeffrey_at_cradle.com.tw>
Date: 1998/02/19
Message-ID: <6ch1t5$n72_at_news.seed.net.tw>#1/1


Hi, I got a problem, please help me!
[Quoted] [Quoted] I want to insert a string with '&' into my table, but Oracle always [Quoted] [Quoted] recognized the &... as a variable and asked me to input a value... Here's my [Quoted] [Quoted] [Quoted] [Quoted] trouble...

[Quoted]     create table test ( name varchar2(32) ); [Quoted]     insert into test values ('Butter&Bread'); [Quoted] [Quoted] 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 [Quoted] [Quoted] '\&' ,'"&' , '&&', but they didn't work and I can't get information from my [Quoted] reference book, could someone help me about it? Please! Thanks. [Quoted] [Quoted] BTW, how about single quotation mark? Received on Thu Feb 19 1998 - 00:00:00 CET

Original text of this message