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

From: Srinivasa Kunamneni <eleeb02_at_menudo.uh.edu>
Date: 1996/07/06
Message-ID: <4rkb3a$4lj_at_masala.cc.uh.edu>#1/1

Tan La (TLa_at_mtl.marconi.ca) wrote:

: In article <4rgr6s$9dh_at_sol.sun.csd.unb.ca>, pmccarth_at_rpc.unb.ca says...

: >
: >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

: If you using SQL*Plus, you can define the substitution character('&') : to other character by using the Set Define command.  

: e.g set define '~'  

: Hope this helps.

try set scan off :

Srini Kunamneni Received on Sat Jul 06 1996 - 00:00:00 CEST