Re: Oracle SQL*Plus and the '&' character ...... help needed .....
From: Mike Rife <rife_at_moffitt.usf.edu>
Date: 1996/05/30
Message-ID: <4oketm$7t9_at_mother.usf.edu>#1/1
Date: 1996/05/30
Message-ID: <4oketm$7t9_at_mother.usf.edu>#1/1
In article <31A61946.5DDF_at_spry.com>, jeremiah_at_spry.com says...
>
>Ian Lang wrote:
>>
>> 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 :' .
>
>By now you undoubtedly have fixed this, but why not get the rowid, and
update the
>value where rowid = nnn?
>
>Funny, 'F&GS' doesn't sound like a number to me. Must be one of those
irrationals.
>--
Just "SET SCAN OFF" to disable the scanning for the "&" character in SQL*Plus. Received on Thu May 30 1996 - 00:00:00 CEST