Re: Problem Inserting "&" sign. (ie. Sampson & Son's)

robert <nix_at_gate.net> wrote:
>If you are using the defines at all anyway then just use
>set define off
>
>Patrick McCarthy wrote:
>>
>> I am trying to insert values into a record using Oracle 7.1.4 on Solaris 2.4
>> Sun workstation. The problem is that I am trying to insert a text value which
>> has the "&" sign in the text array. ie "Maclary & Son's". It keeps coming up
>> with the message insert a value for Son's ?????? It obviously use the "&" to
>> insert a variable field. How can I disable this ????
>>
>> Thanks
>> Patrick McCarthy
>> pmccarth_at_rpc.unb.ca

Robert,

Don't you think the following is more appropriate.

set escape ON
insert into table values ('Maclary \& Son''s');

By disabling define (set define off) you are not permitting SQL*Plus to scan commands for substitution variables and replace them with their values.

Naren Chintala
naren_at_mink.att.com Received on Thu Jul 11 1996 - 00:00:00 CEST