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

From: Pete Etten <ettenp_at_reston.btna.com>
Date: 1998/02/19
Message-ID: <6chdpt$f5r$1@news1-alterdial.uu.net>#1/1

Type 'set define off' at SQL*Plus prompt.

News wrote in message <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 Thu Feb 19 1998 - 00:00:00 CST