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

Or you can just type:

SQL> set scan off

This will disable scanning for ampersands. Patrick Flahan

Adrian Shepherd wrote in message <6ci25i$un$1_at_plutonium.btinternet.com>...
>Try
>
>insert into test vales 'Bread'||'&'||'butter'
>
>Had the same problem just yesterday...
>
>
>AMARENDRA B NETTEM wrote in message
><34EC817E.70AD6519_at_charlie.cns.iit.edu>...
>>Hi,
>>Try this
>>
>>SQL> SET ESCAPE ON
>>SQL> INSERT INTO TEST VALUES('X\&Y');
>>-----------------------------------------------------------
>>
>>SQL>DESC TEST
>> Name Null? Type
>> ------------------------------- -------- ----
>> VALUE VARCHAR2(10)
>>
>>SQL>SET ESCAPE ON
>>
>>SQL>SHOW ESCAPE
>>escape "\" (hex 5c)
>>
>>SQL>INSERT INTO TEST VALUES('X\&Y');
>>
>>1 row created.
>>
>>SQL>SELECT * FROM TEST;
>>VALUE
>>----------
>>X&Y
>>
>>
>>AMARENDRA
>>Pete Etten wrote:
>>
>>> Type 'set define off' at SQL*Plus prompt.
>>>
>>> News wrote in message <6ch1t5$n72_at_news.seed.net.tw>...
>>> >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?
>>> >
>>> >
>>
>>
>>
>>--
>>*****************************************************************
>>AMARENDRA B NETTEM
>>Oracle Certified DBA (OCP)
>>Whittman-Hart Inc.,
>>311 South Wacker Drive, Suite 3500
>>Chicago, IL 60606.
>>
>>Residence:
>>-----------
>>5039 N E River Road,
>>Apt. 1A
>>NORRIDGE, IL 60656
>>
>>
>>Ph.No. (708) 583 9870 (H)
>> (312) 913 6758 (W)
>>
>> E-mail:nettama_at_charlie.cns.iit.edu,
>> anettem_at_whittman-hart.com
>>
>>Homepage: http://www.iit.edu/~nettama
>>
>>****************************************************************
>>Opinions are mine and do not necessarily reflect those
>>of Whittman-hart Inc.
>>
>>
>
>
Received on Thu Feb 19 1998 - 00:00:00 CST