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

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

How can insert '&' in my string?

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

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

Original text of this message

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