Re: Inserting text including &

Richard Gowan 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.
>
> Regards,
>
> Richard Gowan
>
> DBAOracle wrote:
> >
> > I assume you are doing this in sql*plus, where the & represents a variable.. to
> > get around the problem you have to do this:
> >
> > insert into table
> > (col1)
> > values
> > ('this is a test'||'&'||'this is not');
> >
> > Note that you seperate the & into it's own
> > quotes and cat it to the other
> > values.
> >
> > Robert

Hi,

use the svrmgrl instead of SQL*PLUS. This works, as long as svrmgrl still exists...

Greetings

Hans Pfeiffer Received on Sun Aug 01 1999 - 18:15:25 CDT