Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How can insert '&' in my string?
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
![]() |
![]() |