Re: How do to insert '&' character from sqlplus ?

You can use set escape on and use backslash.

SET ESCAPE ON; '\&'

Mladen Gogala wrote:
> On Thu, 08 Jul 2004 08:12:26 -0700, jose luis fernandez diaz wrote:
>
>

>>Hi,
>>
>>When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>>
>>How can I insert '&' character from sqlplus ?
>>
>>Thanks,
>>Jose Luis.