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

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. Received on Thu Jul 04 1996 - 00:00:00 CEST