Re: How to insert data containing a &

In sqlplus you say

set scan off

If you want to have another character, e. g. '*' as the variable parameter, say

set define *

Martin

Adrian Harrison wrote:
>
> Using Oracle 7.3 server for NT
>
> I have a text field that conatins the "&" character.
>
> Whenever I try to insert the record I keep getting prompted to input a value - how do I make this
> char a literal?
>
> Any ideas?
>
> Thanks
>
> Adrian Harrison
Received on Sun Feb 13 2000 - 06:30:21 CST