Re: How to insert data containing a &

Try this :

suppose you want to thrust the value 'Research & Development' in the departmentname column of the department table: insert into department values ( ..., 'Research &' || " Development', ...);

Verma

Adrian Harrison <adrianh_at_globalnet.co.uk> wrote in article <p2vl9sodmn8lg2p0o0t5an9rau2mq8mbim_at_4ax.com>...
> 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 sdo I make this
> char a literal?
>
> Any ideas?
>
> Thanks
>
> Adrian Harrison
>
Received on Sat Feb 05 2000 - 23:43:58 CST