Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can insert '&' in my string?

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

From: Steve Jelfs <s.jelfs_at_btinternet.com>
Date: 1998/02/19
Message-ID: <34EC3CBF.5E8C@btinternet.com>#1/1

News 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?

Ho hum......         

	SET DEF OFF
	create table test ( name  varchar2(32) );
	insert into test values ('Butter&Bread');

	SET DEF ON

Should do the trick!!

Sj Received on Thu Feb 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US