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

Hi,

I guess you are using SQL*Plus. If so, just define your escape character:
SET ESCAPE \
Now you can do an insert like:
INSERT INTO TEST VALUES ('\&'); Regards,

Michael Ringbo, mri_at_dde.dk

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