Re: Inserting text including &

On Mon, 02 Aug 1999 00:04:04 +1000, Richard Gowan <roxl_at_ozemail.com.au> wrote:

>
>
>It's also possible to tell SQL*Plus to ignore the &. I can't remember the option, but it'll be under the online help
>for keyword SET.
>
>

try
set escape='\'
insert 'Tom \& Jerry'

in sql plus of course

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email