Re: Inserting text including &

before running the insert statement enter:

SET DEFINE OFF; Ken

Khal wrote:

> Hello there,
> I need some help inserting a text field that includes an &.
>
> example:
>
> insert into table_name values ('word1 & word2');
>
> This would cause sqlplus to prompt me for the value of word2.
>
> anyway to solve that problem.
> Thanks a million in advance.
>
> Khal
Received on Mon Jul 05 1999 - 07:07:01 CDT