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

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 CET