Re: Oracle SQL*Plus and the '&' character ...... help needed .....

Ian Lang <langi_at_netspace.net.au> wrote:

Ian,

What you need to do is the following:

In your script ...

SET DEFINE OFF This disables the & as a substitution prefix.

Joanne Corcodilos

>Hi,
> Currently I have a table ( Oracle V7.2.3 ) that has data in a field that
>contains the '&' character. The field name is component_number and the
>data is 'F&GS '. I want to change this data to something else but each
>time I run the script is comes back and says 'Enter value for GS :' . It
>thinks that it is a variable. How do I get the script to run straight
>through and get SQL*Plus to recognise this '&' as data.?? Do I use some
>other character that oracle recognises as the & character ?. I am getting
>frustrated and would apreciate any help someone can give.
 

> Please reply here in this newsgroup or e-mail me directly at
>langi_at_netspace.net.au
 

> Thanks, Ian Lang
Received on Wed May 22 1996 - 00:00:00 CEST